Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation 'like'<br>select count(*) as total from ***_ecms_doctor where checked=1 and classid in (90,95,96,97) and (sex like '%女%')