Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation 'like' [ SQLÓï¾ä ] : SELECT count(id) as num FROM view_productPostFull where ( productName like '%̩�����%' ) 1