Skip to content

Instantly share code, notes, and snippets.

@jamesnguyen101

jamesnguyen101/latin1_to_utf8.sql

Created March 26, 2016 08:22
Show Gist options
  • Save jamesnguyen101/1484e54183655f7068d8 to your computer and use it in GitHub Desktop.
Save jamesnguyen101/1484e54183655f7068d8 to your computer and use it in GitHub Desktop.
Download ZIP
How to convert latin1_swedish_ci data into utf8_general_ci?
Raw
latin1_to_utf8.sql
SELECT convert(cast(convert(LATIN1_FIELD using latin1) as binary) using utf8)
FROM LATIN1_TABLE;
-- http://stackoverflow.com/questions/12756877/how-to-convert-latin1-swedish-ci-data-into-utf8-general-ci
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment