Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like': SELECT *, CASE WHEN MATCH(es) AGAINST ("pu��aladas" IN BOOLEAN MODE) THEN 1 ELSE 0 END AS titulo, CASE WHEN MATCH(tags) AGAINST ("pu��aladas" IN BOOLEAN MODE) THEN 1 ELSE 0 END AS etiquetas, CASE WHEN MATCH(es_txt) AGAINST ("pu��aladas" IN BOOLEAN MODE) THEN 1 ELSE 0 END AS texto FROM noticias WHERE publicar != "" && archivo != 1 && papelera != 1 && publicada = 1 && publicar <= "2021-10-22 06:24:22" && (es LIKE "%pu��aladas%" OR tags LIKE "%pu��aladas%" OR es_txt LIKE "%pu��aladas%" OR MATCH(es, tags, es_txt) AGAINST ("pu��aladas" 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