Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_et_0900_ai_ci,IMPLICIT) for operation ‘=’
数据库排序规则。一般是不对等的排序规则。
我这里原因是 以(utf8mb4_0900_ai_ci,IMPLICIT) 为排序规则的字段 连接了 以(utf8mb4_et_0900_ai_ci,IMPLICIT) 为排序规则的字段
从而异常。navicat设计数据库 将字段改回即可
相关文章
- Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_et_0900_ai_ci,IMPLICIT) for ope
- mysql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '= 的解决
- Mysql Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
- Mysql查询报错：Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
- 【MySQL】Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and ...
- 【mysql】【转发】[Err]1267 - Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,I
- java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' 异常处理，及MySQL数据库编码设置
- ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
- Django的admin管理系统写入中文出错的解决方法/1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘locate’
- 解决Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COER