roundcubevnz / myroundcube

Automatically exported from code.google.com/p/myroundcube
GNU General Public License v3.0
0 stars 0 forks source link

[db_config] encodings in plugins configuration #747

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
Token: 477454a0a1ee5f60295441a1dca311a8 (Don't modify this token!)
Version: 26.0.9 (13-10-2014)
PHP: 5.4.34-pl0-gentoo
RCMAIL: 1.0.3
Database: mysql
SERVER: Apache
----
I.  Issue Description:
Saves "????" instead "тест"

II. Steps to reproduce the Issue:
1. open configuration.
2. write: "# тест".
3. save.
4. reopen configuration.
5. "# ????"

Original issue reported on code.google.com by ale...@gelicon.ru on 11 Nov 2014 at 12:41

GoogleCodeExporter commented 8 years ago
There is no reason to use non-ascii chars in config files not even for 
comments. Write your comments into separate files.

Original comment by myroundc...@gmail.com on 11 Nov 2014 at 2:40

GoogleCodeExporter commented 8 years ago
Ok. 

Want to see the names of calendars and address books localized.

$config['def_carddavs'] = array(
  'Рабочий' => array(
                   'user' => '%u',
                   'pass' => '%p',
                   'url' => 'http://dav.mydomain.tld/addressbooks/%u/Рабочий',
                   'readonly' => false,
                 ),
  'Персональный' => array(
                   'user' => '%u',
                   'pass' => '%p',
                   'url' => 'http://dav.mydomain.tld/addressbooks/%u/personal',
                   'readonly' => false,
                 ),
  'Семья' => array(
                   'user' => '%u',
                   'pass' => '%p',
                   'url' => 'http://dav.mydomain.tld/addressbooks/%u/family',
                   'readonly' => false,
                 ),
  'Collected' => array(
                   'user' => '%u',
                   'pass' => '%p',
                   'url' => 'http://dav.mydomain.tld/addressbooks/%u/collected',
                   'readonly' => false,
                 ),
);
...

Original comment by ale...@gelicon.ru on 11 Nov 2014 at 5:14

GoogleCodeExporter commented 8 years ago

Original comment by myroundc...@gmail.com on 11 Nov 2014 at 5:32

GoogleCodeExporter commented 8 years ago
Please check collation of database table 'db_config' and change to UTF8:

ALTER TABLE `db_config` CHANGE `env` `env` VARCHAR(255) CHARACTER SET utf8 
COLLATE utf8_general_ci NOT NULL; 
ALTER TABLE `db_config` CHANGE `conf` `conf` LONGTEXT CHARACTER SET utf8 
COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `db_config` CHANGE `admin` `admin` VARCHAR(128) CHARACTER SET utf8 
COLLATE utf8_general_ci NOT NULL; 

Original comment by myroundc...@gmail.com on 15 Nov 2014 at 5:19

GoogleCodeExporter commented 8 years ago
Fixed (included DB update script for MySQL).

Original comment by myroundc...@gmail.com on 15 Nov 2014 at 6:13

GoogleCodeExporter commented 8 years ago

Original comment by myroundc...@gmail.com on 15 Nov 2014 at 6:15

GoogleCodeExporter commented 8 years ago
Thank you.

Original comment by ale...@gelicon.ru on 15 Nov 2014 at 10:25