mysql设置utf8方法

转自：http://blog.csdn.net/u014657752/article/details/48206885

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;

===================================================================

Sic Parvis Magna