错误:"Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='"
需要把字符集排序规则改为utf8mb4
数据库,表,字段都要改
![](https://img-blog.csdnimg.cn/img_convert/3690194c0a9e99164de407c602d3522d.png)
image.png
错误:"Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='"
需要把字符集排序规则改为utf8mb4
数据库,表,字段都要改