COLLATE=utf8mb4_0900_ai_ci
时间: 2023-08-15 18:06:37 浏览: 259
COLLATE=utf8mb4_0900_ai_ci是表示字符集和排序规则的参数,它在MySQL 80版本中引入。然而,在MySQL 5.6版本中是不支持这个参数的,所以当你尝试将MySQL 8.0版本的SQL文件导入到MySQL 5.6版本时,会出现Unknown collation: ‘utf8mb4_0900_ai_ci‘的错误。 这样就可以解决COLLATE=utf8mb4_0900_ai_ci导致的兼容性问题了。<em>1</em><em>2</em><em>3</em>
#### 引用[.reference_title]
- *1* [Unknown collation: ‘utf8mb4_0900_ai_ci‘的解决方法](https://blog.csdn.net/weixin_42914989/article/details/113155204)[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]
- *2* *3* [MySQL数据库导入SQL报错 Unknown collation: ‘utf8mb4_0900_ai_ci‘的解决办法](https://blog.csdn.net/weixin_44684272/article/details/119821853)[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]
[ .reference_list ]