Arquivo de Notícias

Erro de contagem de registros: SELECT COUNT(*) FROM conteudo AS cont, secao AS sec, imagens AS img WHERE ( cont.texto like '%francisco%' or cont.titulo like '%francisco%' or cont.resumo like '%francisco%' or cont.texto like '%so%' or cont.titulo like '%so%' or cont.resumo like '%so%' ) AND (cont.secao = sec.sid) AND (cont.id = img.id_conteudo) AND cont.opiniao='nao' AND cont.status='sim' AND cont.agendamento<='1495973694' AND cont.validade>='2017-05-28' ORDER BY cont.id DESC. Mysql informa: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like'