MYSQL数据插入 乱码问题 default-character-set=latin1改成default-character-set=utf8 在my.ini文件中。需要改动两处

1.      设置Mysql的编码格式（注意是在创建数据库之前就要设置）

 

找到Mysql安装目录下的 myini文件，用记事本打开，找到以下两句：

 

 

[mysql]

 

default-character-set=latin1

 

--------------------------------------------------------------------------------------------------

 

[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.0/"

 

#Path to the database root

datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

 

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

# created and no character set is defined

default-character-set=latin1

 

 

 

 

 

                  我们需要做的是将这两处的默认编码格式由“latin1”改成“gb2312”。

 

                  改好之后，重启Mysql 。