Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like': SELECT *, CASE WHEN MATCH(es) AGAINST ("Son Ll��tzer" IN BOOLEAN MODE) THEN 1 ELSE 0 END AS titulo, CASE WHEN MATCH(tags) AGAINST ("Son Ll��tzer" IN BOOLEAN MODE) THEN 1 ELSE 0 END AS etiquetas, CASE WHEN MATCH(es_txt) AGAINST ("Son Ll��tzer" IN BOOLEAN MODE) THEN 1 ELSE 0 END AS texto FROM noticias WHERE publicar != "" && archivo != 1 && papelera != 1 && publicada = 1 && publicar <= "2021-10-17 02:57:24" && (es LIKE "%Son Ll��tzer%" OR tags LIKE "%Son Ll��tzer%" OR es_txt LIKE "%Son Ll��tzer%" OR MATCH(es, tags, es_txt) AGAINST ("Son Ll��tzer" IN BOOLEAN MODE)) HAVING (titulo > 0 OR etiquetas > 0 OR es_txt > 0) ORDER BY titulo DESC, etiquetas DESC, texto DESC, publicar DESC limit 100