Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT)
1.修改字段的字符编码
ALTER TABLE table_name MODIFY COLUMN column_name VARCHAR(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT “” COMMENT ‘字段备注’;
2.在‘=’左边或者右边加上字符编码描述COLLATE utf8mb4_general_ci
se...
原创
2019-11-14 11:45:53 ·
398 阅读 ·
0 评论