Correcting wrong character encoding in MySQL data


/ Published in: MySQL
Save to your folder(s)

When you forget to "SET NAMES utf8", you'll probably end up with a bunch of latin1 data in your utf8 column. This query fixes that, CONVERTing the existing data to its correct collation.


Copy this code and paste it in your HTML

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.