MYSQL查看修改字符集

==查看字符集==

 

//查看MySQL数据库服务器和数据库字符集 show variables like '%char%';

//查看表的字符集 show table status from mysql_db like '%tb_name%'

//查看表中所有列的字符集 show full columns from tb_name;

//查看mysql所支持的字符集 show charset;

 

==修改字符集==

 

//修改全局字符集

set character_set_connection=gb2312;

set character_set_database=gb2312;

set character_set_results=gb2312;

set character_set_server=gb2312;

set character_set_system=gb2312;

set collation_connection=gb2312;

set collation_database=gb2312;

set collation_server=gb2312;

 

//修改表的字符集 ALTER TABLE tb_name CONVERT TO CHARACTER SET gb2312;

 

//修改字段字符集 alter table tb_name modify column tb_column varchar(30) character set gb2312 not null;