Hi list,

I have an OTRS 2.4.7 in iso-8859-1 charset mode and I would put it in utf-8.

My sql database should be in utf-8 mode.

mysql> SHOW VARIABLES LIKE "character_set_%" ;

+--------------------------+----------------------------+
| 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.10 sec)

All rows must be in utf-8 ?

In Otrs, when I change $Self->{DefaultCharset} to 'utf-8', Otrs works but the Sysconfig link doesn't work.

Do you have a procedure ?
I found that http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=52

I must have to convert all data ? (by mysqldump ? )

Thanks in advance.

Best 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