MySQL : Fix special characters after migration to UTF-8.

Few days ago, after a hardware crash, I had reinstalled a MySQL server, I saw a display problem with accents.

To fix it easily, you must use the MySQL command convert.

CONVERT(CAST(CONVERT(title USING latin1) AS BINARY) USING utf8), convert Latin-1 characters to UTF-8 characters.

To update all “titles” in “comments” use UPDATE comments SET title = CONVERT(cast(CONVERT(title USING latin1) AS BINARY) USING utf8);

Leave a Reply

Your email address will not be published. Required fields are marked *