My SQL does not find accented words

Question

My SQL works perfectly when the word to be searched is not sharp, however, when the word is stressed, there is no result in the search.

My database is mysql and in the php admin I made the consultation, and finds perfectly accented words also.

Follows my SQL

select id, linkbanner, video, detalhes, mapa, categoria, id_categoria, pagina_descricao, titulo, email, detalhe_contato, endereco, endereco2, site, face, inst, blog, plus, twitter, skype, banner, pop, exibir_pop from anuncios where titulo LIKE '%$strbuscar%'

Answer 1

Put this in your bank

ALTER DATABASE `sua_base` CHARSET = Latin1 COLLATE = latin1_swedish_ci;

More information follows the link -> What character encoding (Collation) should I use in Mysql? Note. I recommend using utf8 instead of latin