Advanced Search

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.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. UPDATE table SET column=CONVERT(CONVERT(CONVERT(column USING latin1) USING binary) using utf8);

Report this snippet


Comments

You need to login to view comments.