Arquivo de Notícias

Erro de contagem de registros: SELECT COUNT(*) FROM conteudo WHERE ( texto like '%pedr%' or titulo like '%pedr%' or resumo like '%pedr%' or texto like '%jao%' or titulo like '%jao%' or resumo like '%jao%' ) ORDER BY id DESC. Mysql informa: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like'