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 '%do%' or cont.titulo like '%do%' or cont.resumo like '%do%' or cont.texto like '%criao%' or cont.titulo like '%criao%' or cont.resumo like '%criao%' ) AND (cont.secao = sec.sid) AND (cont.id = img.id_conteudo) AND cont.opiniao='nao' AND cont.status='sim' AND cont.agendamento<='1539882057' AND cont.validade>='2018-10-18' ORDER BY cont.id DESC. Mysql informa: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'