SQL - Select all records with encoding errors

Question

Make a select in the database bringing all records with coding errors:

SELECT * FROM tabela WHERE titulo LIKE '%ÇÃ%'

Does anyone know another more efficient way?

Answer 1

You can check data that is not in UTF-8 comparing the sizes:

SELECT * FROM suaTabela
WHERE LENGTH(suaColuna) != CHAR_LENGTH(suaColuna)

This will return all lines you have multibyte. Follows the source.