//查询字符集相关数据
SHOW VARIABLES LIKE 'collation_%'
//查询编码相关数据
SHOW VARIABLES LIKE 'character_%';
//修改服务器
SET collation_server = utf8_general_ci;
//修改链接层
SET collation_connection = utf8_general_ci;
//修改数据库 ("database_test")
ALTER DATABASE database_test CHARSET = utf8 COLLATE = utf8_general_ci;
//修改表 ("table_test")
ALTER TABLE table_test COLLATE = utf8_general_ci;
网友评论