Hi list, I ask this question again. Sorry for double How to change default charset for OTRS from iso-8859-1 to UTF-8? I have OTRS 2.3.2 with some data I don't want lose. In SysConfig - Framework#Core I can't change defaultcharset. If I put $Self->{'DefaultCharset'} = 'utf-8' in Config.pm, restart otrs (rcotrs stop & rcotrs start) the link System Configuration doesn't work. More trouble, my otrs database seems to be in utf-8. (it's propably that why I have problem with encoded caracters) !
mysql> use otrs
Database changed
mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
Thanks in advance Regards, -- Guillaume REHM Centre de Ressources Informatiques Responsable Sécurité du Système d'Information (RSSI) Bibliothèque Nationale et Universitaire de Strasbourg 5 rue du Maréchal Joffre BP 51029 67070 Strasbourg tél: 03 88 25 28 23 fax: 03 88 25 28 03 mail: guillaume.rehm@bnu.fr web: http://www.bnu.fr