1. Chinese Writing garbled problem:
I entered the Chinese code is Urf8, built library is Urf8, but inserted MySQL is always garbled, a bunch of "???????????????????????"
I used the Ibatis, finally found the reason, I was so resolved:
The original URL address is: jdbc:mysql://localhost:3306/comment1
Instead: Jdbc:mysql://localhost:3306/comment1?? Useunicode=true&characterencoding=utf-8
It's OK.
2.Incorrect string value: ' \xf0\x9f ' for column ' XXX ' at row 1
The problem, because the UTF-8 encoding could be two, three, four bytes. Emoji emoticons or some special characters are 4 bytes, and MySQL UTF8 encode up to 3 bytes, so data is not plugged in.
That's my solution.
1. Locate the My.ini in the MySQL installation directory and make the following changes:
[Mysqld]
Character-set-server=utf8mb4
[MySQL]
Default-character-set=utf8mb4
Restart MySQL after modification convert the already built tables to UTF8MB4
Command: ALTER TABLE table_name convert to Character set UTF8MB4 collate utf8mb4_bin; (Replace table_name with your table name)
And then it's OK. A version of the online spread adds a step that will character_set_client,character_set_connection,character_set_database,character_ the MySQL environment variable Set_results,character_set_server all changed into UTF8MB4.
But I did not do this step, also normal, so may be this step is superfluous.
Reference article:
http://blog.csdn.net/likendsl/article/details/7530979