PHPCMS 更新后 Illegal mix of collations错误

前几天不是说phpcms有漏洞么,把网站给升级了,发文章时就出现了这个错误,看了下,应该是升级时的sql没有指定编码。

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COER)

修改一下编码能解决,注意表前缀
[sql]
ALTER TABLE keyword CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE keyword_data CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE keyword CONVERT TO CHARACTER SET gbk;
ALTER TABLE keyword_data CONVERT TO CHARACTER SET gbk;
[/sql]

发表评论