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

select COUNT(DISTINCT p.products_id) as total from products p left join products_description pd on (p.products_id = pd.products_id) where pd.language_id = '1' and ((pd.products_name like '%notre%' or pd.products_subname like '%notre%' or pd.products_keywords like '%notre%') and (pd.products_name like '%dame%' or pd.products_subname like '%dame%' or pd.products_keywords like '%dame%') and (pd.products_name like '%lĀ?assomption%' or pd.products_subname like '%lĀ?assomption%' or pd.products_keywords like '%lĀ?assomption%'))

[TEP STOP]