When migrating an application you may want to convert from Latin1 (ISO 88xx) charset to the most comprehensive Unicode UTF-8.
- First of all made a dump of your database table.
- Use iconv as follows:
iconv -c -f latin1 -t utf-8 filename.sql > filename-utf8.sql
- Backup the old table and truncate it.
- Ensure every field has collation in utf8
- Replace “latin1″ with “utf8″ in filename-utf8.sql
- Reimport data and have fun