============================================================================= Mysql_Query : select count(distinct uid) from morning_goods_table as M
LEFT OUTER JOIN award_table as B
ON M.uid = B.ps_goid WHERE M.approval_date > 0 AND (( replace(M.goods_name,' ','') LIKE '%占실울옙占쏙옙占쏙옙占쏙옙占�%' OR replace(M.goods_name2,' ','') LIKE '%占실울옙占쏙옙占쏙옙占쏙옙占�%' OR replace(M.goods_etc1,' ','') LIKE '%占실울옙占쏙옙占쏙옙占쏙옙占�%' OR replace(M.goods_tag,' ','') LIKE '%占실울옙占쏙옙占쏙옙占쏙옙占�%' ) OR ( M.goods_name LIKE '%占실울옙占쏙옙占쏙옙占쏙옙占�%' OR M.goods_name2 LIKE '%占실울옙占쏙옙占쏙옙占쏙옙占�%' OR M.goods_etc1 LIKE '%占실울옙占쏙옙占쏙옙占쏙옙占�%' OR M.goods_tag LIKE '%占실울옙占쏙옙占쏙옙占쏙옙占�%' )) Mysql_Error : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation 'like' Mysql Error Num : 1267 =============================================================================