项目要从oracle迁移mysql 发现 mysql的唯一索引不区分大小写, 会报错
错误代码: 1062
Duplicate entry '8a84cc20713c2a570171bfb3515e5fb6' for key 'PM_SIN_PROJECT_INFO.PRIMARY'
有两种解决方案
在创建表的时候在该字段加唯一索引,binary是为了英文区分大小写
`ID_NO` VARCHAR(32) BINARY NOT NULL COMMENT '注释',
COLLATE 改变成utf8mb4_bin
ENGINE = INNODB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin