Guten Tag Ivan De Masi,
am Mittwoch, 10. März 2010 um 14:02 schrieben Sie:
IDM> here's also a good howto if your going to convert your database or
IDM> single tables:
IDM> http://en.gentoo-wiki.com/wiki/Convert_latin1_to_UTF-8_in_MySQL
I had problems when using iconv because it crashs if files
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_%" ;
>
> +--++
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 -uUse
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 |
+---