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 '%apple%' OR    LOWER(product_code ) LIKE '%apple%' OR    LOWER(brief_description) LIKE '%apple%' )  AND  ( LOWER(name) LIKE '%iphone%' OR    LOWER(product_code ) LIKE '%iphone%' OR    LOWER(brief_description) LIKE '%iphone%' )  AND  ( LOWER(name) LIKE '%4%' OR    LOWER(product_code ) LIKE '%4%' OR    LOWER(brief_description) LIKE '%4%' )