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