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 '%conceio%' or cont.titulo like '%conceio%' or cont.resumo like '%conceio%' ) AND (cont.secao = sec.sid) AND (cont.id = img.id_conteudo) AND cont.opiniao='nao' AND cont.status='sim' AND cont.agendamento<='1503455173' 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'