Inserting Chinese characters into MySQL (Emoji) appears incorrect string value

When the crawler inserted data into MySQL, it found an error "" "Incorrect String Value: ' \xf0\x9f" ", the problem is because UTF-8 can be two, three, four bytes, emoji expression or some special character is 4 bytes, So the content crawled from the Web page may contain emoticons, while MySQL's UTF8 encoding is up to 3 bytes, so data cannot be plugged in. The solution is as follows:

Find my.cnf under/etc, modify as follows:

[Mysqld]

Character-set-server=utf8mb4

[MySQL]

Default-character-set=utf8mb4

Restart MySQL after modification

The already built table is also converted to UTFMB4:

Change database encoding: Alter DB caitu99 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ;

ALTER TABLE table_name convert to Character set UTF8MB4 collate utf8mb4_bin;

Inserting Chinese characters into MySQL (Emoji) appears incorrect string value