Mysql charset problem

Posted by Newtonx on Server Fault See other posts from Server Fault or by Newtonx
Published on 2010-06-11T14:25:54Z Indexed on 2010/06/11 14:33 UTC
Read the original article Hit count: 418

Filed under:
|
|

I'm trying to import some data from one server to another. But when I do it, I'm having problems with charset.

Words like Goiânia became Goiâni and conceição became conceição

My Application was set to use latin1 charset

Server 1 : MySQL Charset : UTF-8 Unicode (utf8) table collation : latin1_swedish_ci

Server 2 : MySQL Charset: UTF-8 Unicode (utf8) table collation : latin1_swedish_ci

Command I used to export data from server 1 mysqldump -u root -p --default-character-set=iso-8859-1 database_name > db.sql

Command used to restore to server 2 mysql -u root -p database_name < db.sql

© Server Fault or respective owner

Related posts about mysql

Related posts about charset