MySQL Importing UTF8 – Latin1 issue

When migrating from older databases to new version of MySQL. If the old database at some point had used latin1 charset and it was not properly upgraded – you will see strange characters due to latin1 – UTF8 charset issues.

A simple hack is to open the import file and add the line



Note: you replace the line that says utf8.