MySql中文乱码解决

1、创建数据库的时候：CREATE DATABASE `test`
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';
2、建表的时候 CREATE TABLE `database_user` (
`ID` varchar(40) NOT NULL default '',
`UserID` varchar(40) NOT NULL default '',

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

3.修改C:\Program Files\MySQL\MySQL Server 5.5下的my.ini

[mysql]
default-character-set=utf8

[mysqld]

character-set-server=utf8