Chinese write database garbled and incorrect string value: ' \xf0\x9f ... ' for column ' XXX ' at row 1 resolved

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