> 1267 - Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '>'
时间: 2023-10-12 13:03:02 浏览: 77
非法字符、非法字符库
4星 · 用户满意度95%
这个错误是因为在比较操作中使用了不同的字符集。在这个特定的例子中,错误信息显示使用的字符集为utf8mb4_general_ci和latin1_swedish_ci。这种错误通常发生在数据库查询或比较操作中,当比较的两个值使用了不同的字符集时,就会出现这种混合字符集错误。在这个例子中,错误信息指出了比较操作为">",并且使用了utf8mb4_general_ci和latin1_swedish_ci这两种字符集。要解决这个错误,需要确保在比较操作中使用相同的字符集。可以通过修改数据库表或查询的字符集来解决这个问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [【MySQL】1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,...](https://blog.csdn.net/Trees__/article/details/128882483)[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^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
- *3* [数据库执行sql时Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8mb4_general_ci,COERCIBLE...](https://blog.csdn.net/qq_21687123/article/details/124988775)[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^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文