MySQL如何插入Emoji表情

chat_system> UPDATE chat_system.feedback t SET t.ments = '反馈信息测试😂' WHERE t.id = 1
[2020-12-01 21:36:08] [HY000][1366] Incorrect string value: '\xF0\x9F\x98\x82' for column 'ments' at row 1
[2020-12-01 21:36:08] [HY000][1366] Incorrect string value: '\xF0\x9F\x98\x82' for column 'ments' at row 1

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect = 'SET NAMES utf8mb4'
character-set-client-handshake = false
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4

# 设置数据库字符集编码，chat_system为数据库名称，根据自己的实际情况而来
ALTER DATABASE chat_system CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

# 设置数据库表字符集编码，chat_system.feedback_ment_reply为我的数据库下对应的表名称，根据自己的实际情况而来
ALTER TABLE chat_system.feedback_ment_reply CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

SHOW VARIABLES WHERE Variable_name LIKE 'character%' OR Variable_name LIKE 'collation%';

UPDATE chat_system.feedback t SET t.ments = '反馈信息测试😂' WHERE t.id = 1;