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