Am 10.03.2010 10:12, schrieb Guillaume Rehm:
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,
Hello Guillaume, here's also a good howto if your going to convert your database or single tables: http://en.gentoo-wiki.com/wiki/Convert_latin1_to_UTF-8_in_MySQL Good luck! Regards, Ivan