Mysql insert Emoji Error

Mysql insert Emoji Error

Today, I made a function to get fans and found that an error is returned when I insert a nickname 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.