PHPCMS 更新后 Illegal mix of collations错误

尘缘PHPCMS

前几天不是说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]