alter table tablename convert to character SET utf8mb4 COLLATE utf8mb4_unicode_ci;

修改表字段編碼

ALTER TABLE tablename CHANGE fieldname fieldname VARCHAR(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;