– 查询编码
SHOW VARIABLES LIKE ‘%character%’
– 修改数据库编码
set character_set_client = utf8;
set character_set_connection=utf8;
set character_set_database=utf8;
set character_set_server=utf8;
– 设置表的编码
ALTER TABLE database_name.table_name CONVERT TO CHARACTER SET utf8