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

SELECT COUNT(*) as 'products_count' FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) WHERE p.products_status = '1' AND pd.language_id = '2' AND ( pd.products_name LIKE ('%Sättel%') OR pd.products_short_description LIKE ('%Sättel%') OR pd.products_description LIKE ('%Sättel%'))

[XT SQL Error]