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
mono...@gmx.net
System:
Ubuntu 8.04.1/Apache 2.2.8-MOD_PERL/MySQL 5.0.51a/ OTRS 2.3.3
---------------------------------------------------------------------
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/
