Mysql支持emoji表情存储，修改数据库字符集从utf8到utf8mb4

# 对每一个数据库:
ALTER DATABASE `test_hooooop` CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# 对存储emoji表情的表和字段:
ALTER TABLE `ball_comments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `ball_comments` MODIFY COLUMN `comment_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `comment_date_gmt`;

mysqld--verbose --help|grep -A 1 'Default options'

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

 

参考

1. 【mysql 修改编码utf8mb4依旧无法保存表情 Incorrect string value: '\x解决办法】

https://www.jianshu.com/p/31de3eb7df77

2. http://docs.lvrui.io/2016/08/21/%E4%BF%AE%E6%94%B9MySQL%E7%9A%84%E5%AD%97%E7%AC%A6%E9%9B%86%E4%B8%BAutf8mb4/