2009
11.08

MySQL: Strange characters appear while import data with apostrophe – UTF8 – Latin1 issue

Category: Linux, MySQL / Tag: ,  / Add Comment

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

/*!40101 SET NAMES latin1 */;

Note: you replace the line that says utf8

No Comment.

Add Your Comment

Your Comment