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
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
