支持emoji表情

首先修改my.cnf 

character-set-server = utf8mb4  支持相关字符集

重启db

1 修改db的编码

alter database database_name character set=utf8mb4 collate=utf8mb4_unicode_ci;

2 修改table

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;   

3 column

ALTER TABLE regions CHANGE shippingTime shippingTime VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;