Skip to content

Instantly share code, notes, and snippets.

@jesusbmx

jesusbmx/corregir_caracteres.sql

Last active July 16, 2018 18:23
Show Gist options
  • Save jesusbmx/a6e38b9456e8ec957ef6d4bb744da0ed to your computer and use it in GitHub Desktop.
Save jesusbmx/a6e38b9456e8ec957ef6d4bb744da0ed to your computer and use it in GitHub Desktop.
Download ZIP
Corrigiendo caracteres rotos de utf8 en MySQL
Raw
corregir_caracteres.sql
UPDATE usuarios
SET referencia = REPLACE (referencia, '­', '');
UPDATE usuarios
SET referencia = IFNULL(
CONVERT (
BINARY CONVERT (referencia USING latin1) USING utf8
),
referencia
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment