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

select count(p.products_id) as total from products p left join products_description pd on (p.products_id = pd.products_id) where pd.language_id = '4' and ((pd.products_name like '%famille%' or pd.products_subname like '%famille%' or pd.products_keywords like '%famille%') and (pd.products_name like '%médicis%' or pd.products_subname like '%médicis%' or pd.products_keywords like '%médicis%'))

[TEP STOP]