Guten Tag Guillaume Rehm, Try this: 1) Export the data: mysqldump -uUser -pPassword --default-character-set=utf8 otrs > otrs.sql 2) In otrs.sql: SET NAMES latin1 -> change to -> SET NAMES utf8 and all DEFAULT CHARSET=latin1 -> change to -> DEFAULT CHARSET=utf8 3.) Import the data: mysql -uUser -pPassword otrs_new < otrs.sql am Mittwoch, 10. März 2010 um 10:12 schrieben Sie: GR> Hi list, GR> I have an OTRS 2.4.7 in iso-8859-1 charset mode and I would put it in utf-8. GR> My sql database should be in utf-8 mode. mysql>> SHOW VARIABLES LIKE "character_set_%" ; GR> +--------------------------+----------------------------+ GR> | Variable_name | Value | GR> +--------------------------+----------------------------+ GR> | character_set_client | latin1 | GR> | character_set_connection | latin1 | GR> | character_set_database | utf8 | GR> | character_set_filesystem | binary | GR> | character_set_results | latin1 | GR> | character_set_server | latin1 | GR> | character_set_system | utf8 | GR> | character_sets_dir | /usr/share/mysql/charsets/ | GR> +--------------------------+----------------------------+ GR> 8 rows in set (0.10 sec) GR> All rows must be in utf-8 ? GR> In Otrs, when I change $Self->{DefaultCharset} to 'utf-8', Otrs works GR> but the Sysconfig link doesn't work. GR> Do you have a procedure ? GR> I found that GR> http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=52 GR> I must have to convert all data ? (by mysqldump ? ) GR> Thanks in advance. GR> Best Regards, -- Mit freundlichen Grüßen André Bauer monotek@gmx.net System: Ubuntu 8.04.1/Apache 2.2.8-MOD_PERL/MySQL 5.0.51a/ OTRS 2.3.3