php插入mysql数据乱码,PHP插入mysql数据乱码

1、设置数据库字符集为：utf8_general_ci

2、创建表时设置字符集为：utf8_general_ci

CREATE TABLE `feedback` (

`id` INT(32) UNSIGNED NOT NULL AUTO_INCREMENT,

`create_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

`user_id` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',

`note` VARCHAR(400) NOT NULL,

PRIMARY KEY (`id`),

INDEX `user_id` (`user_id`)

)

COLLATE='utf8_general_ci'

ENGINE=MyISAM

AUTO_INCREMENT=3

;3、php代码连接数据库时：

$con->query("set names 'utf8'");或

mysql_query("set names 'utf8'",$conn);