解决hibernate向mysql插入中文乱码问题（更改MySQL字符集）

failt

1、首先需要修改mysql数据库的配置文件my.ini，此文件放在mysql根目录下。在此文件下查找default-character-set属性，并将其值更改为utf8（注意：不是utf-8，也要注意大小写），这里需要将default-character-set属性全部属性的值修改为utf8。示例：


default-character-set = utf8


提示：default-character-set属性有两

#
# 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=utf8


# 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 5.5/"

#Path to the database root
datadir="C:/Documents and Settings/All Users/Application Data/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=utf8
default-character-set=utf8





2、修改hibernate的配置文件hibernate.cfg.xml，在配置文件配置hibernate.connection.url属性。示例：


<property name="hibernate.connection.url">
       <![CDATA[jdbc:mysql://localhost:3306/daycode?useUnicode=true&characterEncoding=utf8]]>
</property>


注意：此字符串不能写为jdbc:mysql://localhost:3306/daycode?useUnicode=true&characterEncoding=utf8，不然会出现编译错误



设置这些之后乱码问题就解决了

hudeya

鸳鸳相抱何时了，鸯在一边看热闹。

jiang1799

我妈常说,我们家要是没有电话就不会这么穷。

q528

与时俱进，你我共赴高潮!

sdfouhdso888

锻炼肌肉，防止挨揍！

sweli

生，容易。活，容易。生活，不容易。

lichengcom2009

我不是真的喜欢回忆过去，而是现在的时光没有当初值得怀念