Skip to content

Instantly share code, notes, and snippets.

/update_enconding.sql Secret

Created October 2, 2015 13:57
Show Gist options
  • Save anonymous/1d8e842965b56087f2dc to your computer and use it in GitHub Desktop.
Save anonymous/1d8e842965b56087f2dc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update_enconding.sql
SELECT CONVERT(CONVERT(name USING BINARY) USING latin1) AS latin1,
CONVERT(CONVERT(name USING BINARY) USING utf8) AS utf8
FROM users
WHERE CONVERT(name USING BINARY) RLIKE CONCAT('[', UNHEX('80'), '-', UNHEX('FF'), ']')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment