Illegal mix of collations (utf8_general_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation 'like' SQL query : SELECT COUNT(DISTINCT p.productID) FROM SS_products p where categoryID>1 and enabled=1 and ( LOWER(name) LIKE '%纔罩罕罠羔羹%' OR LOWER(product_code ) LIKE '%纔罩罕罠羔羹%' OR LOWER(brief_description) LIKE '%纔罩罕罠羔羹%' ) AND ( LOWER(name) LIKE '%网罩譱%' OR LOWER(product_code ) LIKE '%网罩譱%' OR LOWER(brief_description) LIKE '%网罩譱%' ) AND ( LOWER(name) LIKE '%samsung%' OR LOWER(product_code ) LIKE '%samsung%' OR LOWER(brief_description) LIKE '%samsung%' ) AND ( LOWER(name) LIKE '%e250%' OR LOWER(product_code ) LIKE '%e250%' OR LOWER(brief_description) LIKE '%e250%' )