MySQL Storage emoji error (incorrect string value: ' \xf0\x9f\x98\x84\xf0\x9f) solution

1. Cause of Error:

The MySQL utf-8 code stores 2-3 bytes, while emoji is 4 bytes.

2. Workaround:

Modify the MySQL configuration file, under Windows for My.ini (Linux for my.cnf), the same content is modified.

[Client]default-character-set = Utf8mb4[mysql]default-character-set = Utf8mb4[mysqld]character-set-server = Utf8mb4collation-server = Utf8mb4_unicode_ci

3. Change the corresponding field in the database to Utf8mb4_general_ci

4. In my project, configure the database link URL to the properties file. What must be changed here is to remove the characterencoding=utf-8.

MySQL Storage emoji error (incorrect string value: ' \xf0\x9f\x98\x84\xf0\x9f) solution