mysql utf8mb4：在存储表情符号

时，会发生错误时发生错误时，您会尝试将emojis的名称保存到您的mysql Database中时遇到错误，并使用utf8mb4 encododing ancododing ancod. The issue stems from differences in the database-specific variables between the global settings and your specific database.

Database Configuration Verification

Verify that the global database variables are set to "utf8mb4" for "character_set" and "utf8mb4_unicode_ci" for "collat​​ion" using the query:

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collat​​ion%';

1. For the relevant database, ensure that the above variables are also set to "utf8mb4" and “ UTF8MB4_UNICODE_CI”，分别使用phpmyadmin中的相同查询。

默认字符集= UTF8MB4 [mysqld] ... 字符集合式手持= false 字符 - 设定服务器= UTF8MB4 Collat​​ion-Server = UTF8MB4_UNICODE_CI

在MySQL会话中，将客户端，连接和结果字符设置为UTF8MB4，可能解决该问题。