This article is in English.
MySQL Error: Importing database: Unknown collation: 'utf8mb4_0900_ai_ci'
This is Github / issues of MySQL.
...(Something else not important to solve this issue)...
Opened the .sql file in Notepad++ ( Alternative: Open the .sql file in Microsoft Word ) and hit CTRL+H ( Alternative: [Microsoft Word] hit CTRL + F ) to find and replace the string “utf8mb4_0900_ai_ci” and replaced it with “utf8mb4_general_ci“.
It worked for me ,hope it will work for u as well.
...(Something else not important to solve this issue)...
Source From: https://github.com/drud/ddev/issues/1902
The above content has been modified, e.Ki does not claim any copyright on this article.
这是啥?( ๑´•ω•) "(ㆆᴗㆆ)
就是我用宝塔面板一键安装的 ZFAKA 安装以后,升级数据库,新旧版本数据库支援的解码方式好像不一样,要把 .sql 里面的 utf8mb4_0900_ai_ci 都替换成 utf8mb4_general_ci
请问,你是咋替换的,我的博客数据库用mysql8.0以后也有问题,我在网上搜了许多教程,没解决
如果 .sql 文件不大的话就在word 处理文件里打开 Ctrl + F 找到 utf8mb4_0900_ai_ci (不一定是这个编码,具体还得看导入 sql 的一个错误信息)并替换 成 utf8mb4_general_ci
感谢解答,我的应该也是编码问题
客气
多回来看看孩子