# Homemade tool book # MySQL inserts Chinese characters and obtains garbled data?

In my. ini, the default Character Set of MySQL is latin1. We often use UTF-8 (utf8 in MySQL) and gbk to store Chinese characters.

Therefore, you can add the default charset setting statement at the end of the definition table in a table that needs to store Chinese characters.

The test is successful.

In addition, you can modify my. ini to adjust the global default character set encoding.

In addition, if you use ibatis, You need to configure the following.

Mysql. driver = com. mysql. jdbc. Driver
Mysql. url = jdbc: mysql: // localhost: 3306/ecommsite? UseUnicode = true & characterEncoding = gbk
Mysql. username = root
Mysql. password = *******