Skip to content

Instantly share code, notes, and snippets.

@renepardon

renepardon/convert-to-utf8.sql

Created September 22, 2017 12:14
Show Gist options
  • Save renepardon/642e60f3181a5793779c7768e47abe42 to your computer and use it in GitHub Desktop.
Save renepardon/642e60f3181a5793779c7768e47abe42 to your computer and use it in GitHub Desktop.
Download ZIP
Converting broken data to UTF8 with MySQL
Raw
convert-to-utf8.sql
UPDATE <table> SET <column> = CONVERT(BINARY CONVERT(<column> USING latin1) USING utf8);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment