1
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?
1
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?
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.
Browser other questions tagged sql mysqli
You are not signed in. Login or sign up in order to post.