mysql> create database mydb character set gbk;#直接指定其编码
2)、直接通过命令进行修改
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;
3)、linux系统下,修改MySQL数据库默认编码的步骤为:
SET NAMES 'gbk';
它相当于下面的三句指令:
SET character_set_client =gbk;
SET character_set_results = gbk;
SET character_set_connection = gbk;
1. 创建数据库
mysql> create database name character set gbk;
2. 创建表
CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=gbk;
3. 修改数据库成utf8的.
mysql> alter database name character set gbk;
4. 修改表默认用utf8.
mysql> alter table type character set gbk;
5. 修改字段用utf8
mysql> alter table type modify type_name varchar(50) CHARACTER SET gbk;