1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation 'like'

SELECT distinct count(p.products_id) as anzid, p.products_id, p.products_price, p.products_model, p.products_quantity, p.products_shippingtime, p.products_date_available, p.products_fsk18, p.products_image, p.products_weight, p.products_tax_class_id, p.products_ordered, pd.products_name, pd.products_short_description, pd.products_description, c.categories_id, c.content_id, c.content_file, c.content_meta_description, c.content_name, cd.categories_heading_title FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_to_contents AS pc ON (p.products_id = pc.products_id) LEFT JOIN products_content AS c ON (c.content_id = pc.content_id) LEFT JOIN categories_description AS cd ON c.categories_id !=0 and cd.categories_id = c.categories_id and cd.language_id = '2' LEFT JOIN products_content_stichwort AS pcs ON (c.content_id = pcs.content_id) WHERE pd.language_id = '2' and p.products_status = '1' AND pc.aktivierung = '1' AND ( ( pd.products_keywords LIKE ('%hexaglot%') OR pd.products_description LIKE ('%hexaglot%') OR pd.products_name LIKE ('%hexaglot%') OR p.products_id LIKE ('%hexaglot%') OR p.products_ean LIKE ('%hexaglot%') OR pcs.stichwort LIKE ('%hexaglot%') OR m.manufacturers_name LIKE ('%hexaglot%') ) and ( pd.products_keywords LIKE ('%dialogü%') OR pd.products_description LIKE ('%dialogü%') OR pd.products_name LIKE ('%dialogü%') OR p.products_id LIKE ('%dialogü%') OR p.products_ean LIKE ('%dialogü%') OR pcs.stichwort LIKE ('%dialogü%') OR m.manufacturers_name LIKE ('%dialogü%') ) and ( pd.products_keywords LIKE ('%volltext-Übersetzungscomputer%') OR pd.products_description LIKE ('%volltext-Übersetzungscomputer%') OR pd.products_name LIKE ('%volltext-Übersetzungscomputer%') OR p.products_id LIKE ('%volltext-Übersetzungscomputer%') OR p.products_ean LIKE ('%volltext-Übersetzungscomputer%') OR pcs.stichwort LIKE ('%volltext-Übersetzungscomputer%') OR m.manufacturers_name LIKE ('%volltext-Übersetzungscomputer%') ) ) GROUP BY p.products_id ORDER BY anzid desc

[XT SQL Error]