修改数据库字符集和校对规则

//查询字符集相关数据
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;