When a higher version of mysql, such as mysql8, the exported sql file

is imported into a lower version of mysql

If the utf8mb4 character set is used, this error will occur

ERROR 1273 (HY000) at line 199: Unknown collation: ‘utf8mb4_0900_ai_ci’

The solution is to replace the utf8mb4_0900_ai_ci with utf8mb4_general_ci in the sql file in bulk

Similar Posts:

• [Err] 1273 – Unknown collation:’utf8mb4’u 0900’u ci’
• The solution of job failed to start when modifying MySQL character encoding
• utf8mb4_general_Ci error reporting solution
• PHP Connect MYSQL8.0 Error: Server sent charset unknown to the client. Please, report to the developers
• What is the difference between utf8mb4 Unicode Ci and UTF8 general CI in MySQL database?
• [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
• Android Call requires API level 11 [How to Solve]
• [Solved] Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.6…
• mysqldump unknown table ‘column_statistics’
• Python3.x Error:AttributeError: ‘str’ object has no attribute ‘decode’