my.ini

中设置

[mysql]

?

#default-character-set=latin1

default-character-set=utf8

?

...

?

[mysqld]

?

# The TCP/IP Port the MySQL Server will listen on

port=3306

?

?

#Path to installation directory. All paths are usually resolved relative to this.

basedir="C:/Program Files/MySQL/MySQL Server 5.5/"

?

#Path to the database root

datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"

?

# The default character set that will be used when a new schema or table is

# created and no character set is defined

#character-set-server=latin1

character-set-server=utf8

?

创建

create database test default character set utf8 collate utf8_general_ci;

查看编码情况:

status;

?