mysql 支持emoji
2022-09-23

数据库配置修改:

[client] 

default-character-set = utf8mb4

[mysql]

default-character-set = utf8mb4

[mysqld]

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'


修改已有表字符集:

alter table  xxx convert to character set utf8mb4;