Skip to content

Instantly share code, notes, and snippets.

@ogabrielsantos

ogabrielsantos/dump

Created May 13, 2015 04:17
Show Gist options
  • Save ogabrielsantos/4622644e758c3284c10f to your computer and use it in GitHub Desktop.
Save ogabrielsantos/4622644e758c3284c10f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dump
SELECT CONVERT(CONVERT(COLUNA_ERRADA USING BINARY) USING latin1) AS latin1,
CONVERT(CONVERT(COLUNA_ERRADA USING BINARY) USING utf8) AS utf8
FROM NOME_DA_TABELA
WHERE CONVERT(COLUNA_ERRADA 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