mysql插入中文报错：incorrect string value:...

今天尝试了jsp 中连接mysql数据库插入中文一直报错，搞了我一天的时间

 

到晚上终于搞定了。

 

进入安装目录下的 my.ini修改配置，

有两个地方需要修改，一个是client端的还有一个是server端的

 

# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
[mysql]
default-character-set=gbk//这个地方

# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
[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 6.0/"
#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 6.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=gbk//这个地方
 

 

 

其实这两个地方弄好了，未必就能插入中文，

 

还要在创建数据库的时候 指定 default charset=gbk

 

创建表的时候最好也加上。这样保证你百分百不会在

 

报错了。