php mysql编码如何设置

SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;

mysql> create database name character set utf8;

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;

alter database name character set utf8;

alter table type character set utf8;

alter table type modify type_name varchar(50) CHARACTER SET utf8;