Mysql insert Emoji error _ MySQL

Today, I made a function to get fans. I found that inserting nicknames into the database should have enough Incorrectstringvalue: 39; xF0x9Fx98x84xF0x9F find the point of information found that UTF-8 encoding may be two, three, four bytes. Today, Emoji provides a function for getting fans and finds that an error is returned when inserting nicknames into the database. the length must be enough.

Incorrect string value: '\ xF0 \ x9F \ x98 \ x84 \ xF0 \ x9F

Find some information found that the UTF-8 encoding may be two, three, four bytes. Emoji expressions or some special characters are 4 bytes, while Mysql utf8 can encode up to 3 bytes, so data cannot be inserted.

All online solutions

Modify mysql configurations

1. Find my. ini in the mysql installation directory and make the following changes:
[Mysqld]
Character-set-server = utf8mb4
[Mysql]
Default-character-set = utf8mb4

2 restart

Net stop mysql
Net start mysql

3. modify a table

Alter table name convert to character set utf8mb4 COLLATE utf8mb4_bin;

I only fixed the problem in step 3 and now recorded it.