帝国CMS后台搜索提示“MySQL Illegal mix of collations for operation ‘like’”解决办法

帝国CMS网站搬家时发现后台信息搜索出错，提示如下错误文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/7682.html

Illegal mix of collations for operation 'like'
select count(*) as total from ***_ecms_crm where (title like '%高级%' or sskehu like '%高级%' or ssgs like '%高级%' or domain like '%高级%'文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/7682.html

这是由于升级mysql5.5才会出现的错误，文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/7682.html

只需打开 /e/admin/LisNews.php文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/7682.html

查找：文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/7682.html

$sr['searchallfield'].=$or.$r1[1]." like '%[!--key--]%'";

改为文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/7682.html

$sr['searchallfield'].=$or.$r1[1]." like binary '%[!--key--]%'";

即可文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/7682.html