MySQL Query Error SELECT tags FROM links_key where keyword='自动友情链接'; Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='MySQL Query Error Select keyword,count From links_key where ( CONCAT(tags,' ') like '%自动友情链接 %' ) And Not(keyword like '自动友情链接') and result='0'order by sotime desc limit 0,8; Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation 'like'MySQL Query Error SELECT COUNT(*) FROM links_link WHERE (keywords LIKE '%自动友情链接%' or title LIKE '%自动友情链接%') and result='2' Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation 'like'
MySQL Query Error select * from links_link WHERE (title like '%自动友情链接%' or keywords like '%自动友情链接%' or url like '%自动友情链接%') and result='2' order by style=1 desc,intime desc Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation 'like'