MYSQL Insert Database error Incorrect String value: ' \xf0\xa0\x86\xa2 '

Today, from the Nginx log analysis search keywords, and then insert the keyword into the MySQL database, the following error occurred

SQL state [HY000]; Error code [1366]; Incorrect string value: ' \xf0\xa0\x86\xa2 ' for column ' XXXX ' at row 38; Nested exception is Java.sql.SQLException:Incorrect string value: ' \xf0\xa0\x86\xa2 ' for column ' XXXX ' at row 38

The SQL that is having the problem

Then from the Internet to find the answer,

http://blog.csdn.net/fuxuejun/article/details/20361669

Originally is the MySQL database coding problem, the code from Utf-8 changed to UTF8MB4 on the line

In order to test the simple I have changed the code of the table directly.

ALTER TABLE search_key_detail CONVERT to CHARACTER SET utf8mb4;

And then insert it again, OK.

MYSQL Insert Database error Incorrect String value: ' \xf0\xa0\x86\xa2 '