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 '%itaporanga%' or cont.titulo like '%itaporanga%' or cont.resumo like '%itaporanga%' or cont.texto like '%de%' or cont.titulo like '%de%' or cont.resumo like '%de%' or cont.texto like '%Pedro%' or cont.titulo like '%Pedro%' or cont.resumo like '%Pedro%' 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<='1503447673' AND cont.validade>='2017-08-22' ORDER BY cont.id DESC. Mysql informa: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like'