Mysql charset problem
- by Newtonx
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