MySQL-1273 - Unknown collation:
2023-11-15 本文已影响0人
ravenLu
MYSQL 使用navicat Premium转存SQL语句，生成表执行报错：
CREATE TABLE `t_device_type` (
........
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic
> 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
> 时间: 0s
解决办法
一、将文件中的所有
utf8mb4_0900_ai_ci 替换为 utf8_general_ci
utf8mb4 替换为utf8
[ERR] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci
参考：https://www.jianshu.com/p/c4ba9ef2a86d
