关于数据库存储emoji等高级符号的字符集升级的解决方案

关于数据库存储emoji等高级符号的字符集升级的解决方案

一：背景

mysql5.7，原字符集为utf8，想升级为utf8mb4存储emoji等高级符号

二：数据库ddl案例

第一句：ALTER TABLE tbname MODIFY c1 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci not null default ‘’ comment ‘c1的注释’;
第二句：ALTER TABLE tbname MODIFY c1 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci not null default ‘’;
第三句:【ALTER TABLE tbname MODIFY COLUMN c1 varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci not null,
MODIFY COLUMN c2 varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci not null,
MODIFY COLUMN c3 varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci not null,
MODIFY COLUMN c4 text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci not null,
MODIFY COLUMN c5 varchar(64) CH