mysql编码修改

1.  SET NAMES 'utf8'; 
它相当于下面的三句指令： 
SET character_set_client = utf8; 
SET character_set_results = utf8; 
SET character_set_connection = utf8; 

2. 创建数据库 
mysql> create database name character set utf8; 

3. 创建表
CREATE TABLE `type` ( 
`id` int(10) unsigned NOT NULL auto_increment, 
`flag_deleted` enum('Y','N') character set utf8 NOT NULL default 'N', 
`flag_type` int(5) NOT NULL default '0', 
`type_name` varchar(50) character set utf8 NOT NULL default '', 
PRIMARY KEY (`id`) 
)  DEFAULT CHARSET=utf8; 

4. 修改数据库成utf8的.
mysql> alter database name character set utf8; 

5. 修改表默认用utf8.
mysql> alter table type character set utf8; 

6. 修改字段用utf8
mysql> alter table type modify type_name varchar(50) CHARACTER SET utf8; 

还要修改数据库字符编码：

先关闭mysql服务，MySql的配置文件Windows下my.ini中，把编码修改成utf8，然后重启mysql服务