Hibernate insert Chinese to MySQL database garbled

1. Changing the MySQL database character set

Modify/ETC/MY.CNF under Linux

Modify My.ini under Windows

[Mysqld]
#default-character-set = UTF8

Character_set_server=utf8 #这个是我添加的
init_connect= ' SET NAMES UTF8 '
Datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql.sock
User=mysql
Symbolic-links=0

[Mysqld_safe]
Default-character-set = UTF8 #这个是我添加的
Log-error=/var/log/mysqld.log
Pid-file=/var/run/mysqld/mysqld.pid

[Client]
Default-character-set = UTF8 #这个是我添加的

[Mysql.server]
Default-character-set = UTF8 #这个是我添加的

[MySQL]
Default-character-set = UTF8 #这个是我添加的

Mysql> Show variables like '%char% ';

| character_set_client | UTF8 |

| character_set_connection | UTF8 |

| Character_set_database | UTF8 |

| Character_set_filesystem | binary |

| Character_set_results | UTF8 |

| Character_set_server | UTF8 |

| Character_set_system | UTF8 |

| Character_sets_dir | /usr/share/mysql/charsets/|

2 Data Source URL connection configuration

When you configure a database URL in an XML configuration file, you use the & escape character, which is &amp

<property name= "url" value= "Jdbc:mysql://localhost:3306/customer? Useunicode=true&amp;characterencoding=utf8 "</property>

3.Tomcat

The Tomcat default character set is Iso-8829-1, modified to Utf-8

Modify the Server.xml file

<connector connectiontimeout= "20000" port= "8080" protocol= "http/1.1" redirectport= "8443" URIEncoding= "Utf-8"/ >

Differences in use of UTF8 and UTF-8

Summary: "Utf-8" can only be used in MySQL with the alias "UTF8", but in other places use uppercase "UTF-8". 】

This article is from the "Nothing-skywalker" blog, please be sure to keep this source http://tianxingzhe.blog.51cto.com/3390077/1672424

Hibernate insert Chinese to MySQL database garbled