mysql错误:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

来源:互联网 发布:mysql数据库书籍 编辑:程序博客网 时间:2024/05/17 08:39


-- ALTER DATABASE test CHARACTER SET utf8 COLLATE utf8_general_ci
-- ALTER TABLE zwxsougoupost CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci

set @@character_set_server='utf8';




无用语句:

SHOW VARIABLES LIKE 'character_set_%'

阅读全文
0 0