mysql数据库无法存入表情的解决方法
mysql数据库的默认字符集utf8,只能存储3个字节的数据,标准的emoji表情是4个字节,所以要使用utf8mb4兼容四个字节
可以直接修改数据库的字符集,先查看
show variables like '%character%';
如果是utf8可以直接修改为utfmb4
set character_set_client = utf8mb4;
set character_set_server = utf8mb4;
set character_set_connection = utf8mb4;
set character_set_database = utf8mb4;
set character_set_results = utf8mb4;
set collation_connection = utf8mb4_general_ci;
set collation_database = utf8mb4_general_ci;
set collation_server = utf8mb4_general_ci;
修改库的字符集
alter database 库名 character set utf8mb4 collate utf8mb4_general_ci
修改表的字符集
alter table 表名 character set utf8mb4 collate utf8mb4_general_ci