1、更改服务器的编码方式，在终端输入以下命令：mysqld--character-set-server=gbk--collation-server=gbk_chinese_ci；2更改某个数据库的编码方式mysql-uroot-p alterdatabasecharactersetgbkcollategbk_chinese_ci;
3、在创建数据库时指定编码：mysql-uroot-p createdatabasedb_namecharactersetgbkcollategbk_chinese_ci;
4、更改某个表的编码方式mysql-uroot-pdb_namealtertabletable_nameconvertto charachtersetgbkcollategbk_chinese_ci;
5、在创建表时指定编码方式mysql-uroot-pdb_namecreatetabletable_name(....)charactersetgbkcollategbk_chinese_ci;
6、更改某行的编码方式mysql-uroot-pdb_namealtertabletable_namemodifycolumn_namevarchar(20)charactersetgbkcollategbk_chinese_ci;
7、在创建列时指定编码方式：</pre><prename="code">mysql-uroot-pdb_namecreatetabletable_name(...,col1varchar(20)charactersetgbkcollategbk_chinese_ci,...)charactersetutf8collateutf8_general_ci;
