My SQL does not find accented words [duplicate]

0

My SQL works perfectly when the word being searched is not accentuated, but when the word is accented, there is no search result.

My database is mysql and in php admin I made the query, and it finds perfect words also accented.

Follow 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%'
    
asked by anonymous 26.07.2017 / 18:28

1 answer

0

Put this in your bank

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

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

    
26.07.2017 / 18:46