1.查看当前数据库字符集配置:
show variables like 'character%'
2.将对应的设置成utf8mb4:
SET character_set_system = utf8mb4;
3.执行:
ALTER TABLE sys_robot CHANGE nick_name nick_name VARCHAR(50) CHARACTER SET utf8mb4;
show variables like 'character%'
SET character_set_system = utf8mb4;
ALTER TABLE sys_robot CHANGE nick_name nick_name VARCHAR(50) CHARACTER SET utf8mb4;