|
|
MySQL Importing UTF8 – Latin1 issue - Mysql
|
Views : 231
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
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. |
|
By Rekha, On - 2010-01-28 |
|
|
|
