MySQL-编码字符集
1,查看数据库使用的编码格式
show variables like “%colla%”;
show variables like “%char%”;
2,修改数据库编码为utf8
set character_set_client = ‘utf8’;
set character_set_connection = ‘utf8’;
set character_set_results = ‘utf8’;
3,修改具体某数据库编码
alter database ‘db_name’ default character set utf8 collate utf_general_ci;
4,修改具体某个数据表编码
alter table ‘tb_name’ default character set utf8 collate utf_general_ci;
还没有评论,来说两句吧...