Make a select in the database bringing all the records with coding errors:
SELECT * FROM tabela WHERE titulo LIKE '%ÇÃ%'
Does anyone know of a more efficient way?
SQL - Select all records with coding errors
1
asked by anonymous 05.10.2015 / 17:47
1 answer
1
You can check data that is not in UTF-8 by comparing sizes:
SELECT * FROM suaTabela
WHERE LENGTH(suaColuna) != CHAR_LENGTH(suaColuna)
This will return all rows that have multibyte .
Follow the source .
05.10.2015 / 18:23