MySql命令查看编码

--查看数据库的字符集 show variables like 'character\_set\_%'; show variables like 'collation_%'; --设置数据库字符编码 set names 'GBK' alter database payment character set GBK; create database mydb character set GBK; set character_set_client=gbk; set character_set_connection=gbk; set character_set_database=gbk; set character_set_results=gbk; set character_set_server=gbk; set character_set_system=gbk; set collation_connection=gbk; set collation_database=gbk; set collation_server=gbk;