Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like': SELECT *, CASE WHEN MATCH(es) AGAINST ("Camí de Jes��s" IN BOOLEAN MODE) THEN 1 ELSE 0 END AS titulo, CASE WHEN MATCH(tags) AGAINST ("Camí de Jes��s" IN BOOLEAN MODE) THEN 1 ELSE 0 END AS etiquetas, CASE WHEN MATCH(es_txt) AGAINST ("Camí de Jes��s" IN BOOLEAN MODE) THEN 1 ELSE 0 END AS texto FROM noticias WHERE publicar != "" && archivo != 1 && papelera != 1 && publicada = 1 && publicar <= "2021-11-28 18:08:43" && (es LIKE "%Camí de Jes��s%" OR tags LIKE "%Camí de Jes��s%" OR es_txt LIKE "%Camí de Jes��s%" OR MATCH(es, tags, es_txt) AGAINST ("Camí de Jes��s" 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