关于数据库存储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