Illegal mix of collations (cp1250_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
时间: 2023-08-19 17:11:57 浏览: 41
回答: 出现"Illegal mix of collations"错误是因为在比较两个表的字段时,它们的字符集排序规则不一致。\[1\]\[2\]解决这个问题的方法有两种:
1. 进行数据类型转换:在查询时使用CONVERT函数将字段的字符集排序规则进行转换,例如使用CONVERT(field_name USING utf8) COLLATE utf8_general_ci。
2. 统一字符集排序规则:将两个表的字符集排序规则统一起来,可以通过修改表的字符集排序规则来实现。例如使用ALTER TABLE语句将表的字符集排序规则修改为一致的,如ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci。
希望以上方法能够帮助您解决"Illegal mix of collations"错误。
#### 引用[.reference_title]
- *1* [mysql "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) fo...](https://blog.csdn.net/weixin_41486438/article/details/125294209)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [MYSQL查询报错Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT)](https://blog.csdn.net/weixin_44729970/article/details/122099794)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]