Searches in mysql - Accented letters

Question

Currently I do my search as follows:

SELECT * FROM cadastro WHERE nome LIKE '%são%'

This way does not return me a result, however, when I put only the ã capitalized Ã I get the result.

That’s how it works:

SELECT * FROM cadastro WHERE nome LIKE '%sÃo%'

Could you answer me how I can solve this problem?

Answer 1

Change the type of encoding your bank uses, do so

 ALTER DATABASE `seu_banco`CHARSET = UTF8 COLLATE = utf8_general_ci;