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