I have two systems at hand. One a Debian box, the other a RHEL5 box.
On the Debian box there is a MySQL server (5.0.32-Debian_7etch1) running which hosts Databases from a customized content management system.
This system has grown over time and the tables are stored with different collations.
Now I want to export and reimport the data on the RHEL5 MysQL server (5.0.45).
And here the special character hell begins. It doesn't matter if I reimport the data as utf8, as latin1 or latin1_swedish_ci. Everytime the special characters are wrong and distorted.
Surprisingly the data that is shipped with the unmodified CMS displays the special chars correctly after installation.
But I have to import the modified version from the old server as there are lots of modifications to import.
Does anyone know how to export and reimport such data?
Old server:
Quote:
character set client utf8
(Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_unicode_ci
(Global value) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci
|
New server:
Quote:
character set client utf8
(Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_unicode_ci
(Global value) latin1_swedish_ci
|