MySQL-1273 - Unknown collation:

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