Unknown collation: ‘utf8mb4_0900_ai_ci‘

本文涉及的产品
RDS MySQL DuckDB 分析主实例,集群系列 4核8GB
RDS AI 助手,专业版
简介: Unknown collation: ‘utf8mb4_0900_ai_ci‘

今天在敲代码的时候遇到了一个这样的错误:

这里感谢大佬的文章,经过大佬的指定,问题终于解决了,文章链接在这里,感兴趣的伙伴可以进行参考:

Unknown collation: ‘utf8mb4_0900_ai_ci_unknown collation: 'utf8mb4_0900_ai_ci-CSDN博客

这里简单解释:可能是mysql中高版本的数据库导入低版本的mysql数据库产生的报错

一、将文件中的所有
utf8mb4_0900_ai_ci 替换为 utf8_general_ci
utf8mb4 替换为utf8

先贴一下源码:这里所有的内容,都进行替换就可以了

一条一条复制太复杂了,有什么办法一次性替换,有vscode,进行替换

我们就需要用ctrl+f快捷键,这样就可以使用查找所有的img,并将所有img替换成images,点击左边符号,下面就可以实现替换了。注意替换时不要有空格。

/*
 Navicat Premium Data Transfer
 
 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : ymzting
 
 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001
 
 Date: 07/05/2023 17:36:14
*/
 
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
 
-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `isuse` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕!!!!!!!!!!', '0.00', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕1', '0.00', '#B42020', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕2', '0.00', '#52C827', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕3', '0.00', '#8311A0', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '0.00', '#DD1919', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '', '0.00', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '有时间的弹幕', '8.712107', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '发送弹幕', '4.633285', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '1111', '12.672615', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', 'wwww', '14.069479', '#9A1919', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕', '1.76306', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', 'websocket', '2.344148', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '111', '3.385441', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '5.381284', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '13.613529', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '2.407239', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '5.256298', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '1111', '2.059521', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '11112222', '8.389185', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '测试', '2.234286', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '', '0', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '33333', '3.96462', '#782D2D', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '3254524', '2.795794', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '0.83545', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '7.72843', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '10.960832', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '13.756024', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '15.708912', '#000000', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.765993', '#000000', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '2.432202', '#C50B0B', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '6.952991', '#4429AF', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.168342', '#000000', '0');
INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '2.505749', '#000000', '0');
INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '0', '#000000', '0');
INSERT INTO `comment` VALUES ('grass', 'ymzting', 'wwww', '4.389952', '#000000', '0');
INSERT INTO `comment` VALUES ('grass', 'ymzting', '测试能完结了吗', '3.683333', '#000000', '0');
 
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Table structure for video
-- ----------------------------
DROP TABLE IF EXISTS `video`;
CREATE TABLE `video`  (
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of video
-- ----------------------------
INSERT INTO `video` VALUES ('猫咪', 'cat', '宠物,猫,动物,可爱');
INSERT INTO `video` VALUES ('狗狗', 'dog', '宠物,狗,动物,汪汪');
INSERT INTO `video` VALUES ('大楼', 'build', '大楼,城市,建筑,景色');
INSERT INTO `video` VALUES ('草地', 'grass', '自然,景色,草原,绿色');
INSERT INTO `video` VALUES ('大鹅', 'goose', '动物,家畜,散养,凶猛');
INSERT INTO `video` VALUES ('人', 'people', '人类,摄影,美景');
INSERT INTO `video` VALUES ('很多车', 'manycar', '汽车,城市,生活');
INSERT INTO `video` VALUES ('汽车', 'car', '汽车,奢侈');
 
SET FOREIGN_KEY_CHECKS = 1;

更换的表单

/*
 Navicat Premium Data Transfer
 
 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : ymzting
 
 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001
 
 Date: 07/05/2023 17:36:14
*/
 
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
 
-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `isuse` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕!!!!!!!!!!', '0.00', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕1', '0.00', '#B42020', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕2', '0.00', '#52C827', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕3', '0.00', '#8311A0', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '0.00', '#DD1919', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '', '0.00', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '有时间的弹幕', '8.712107', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '发送弹幕', '4.633285', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '1111', '12.672615', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', 'wwww', '14.069479', '#9A1919', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕', '1.76306', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', 'websocket', '2.344148', '#000000', '0');
INSERT INTO `comment` VALUES ('dog', 'ymzting', '111', '3.385441', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '5.381284', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '13.613529', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '2.407239', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '5.256298', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '1111', '2.059521', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '11112222', '8.389185', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '测试', '2.234286', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '', '0', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '33333', '3.96462', '#782D2D', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '3254524', '2.795794', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '0.83545', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '7.72843', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '10.960832', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '13.756024', '#000000', '0');
INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '15.708912', '#000000', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.765993', '#000000', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '2.432202', '#C50B0B', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '6.952991', '#4429AF', '0');
INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.168342', '#000000', '0');
INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '2.505749', '#000000', '0');
INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '0', '#000000', '0');
INSERT INTO `comment` VALUES ('grass', 'ymzting', 'wwww', '4.389952', '#000000', '0');
INSERT INTO `comment` VALUES ('grass', 'ymzting', '测试能完结了吗', '3.683333', '#000000', '0');
 
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Table structure for video
-- ----------------------------
DROP TABLE IF EXISTS `video`;
CREATE TABLE `video`  (
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of video
-- ----------------------------
INSERT INTO `video` VALUES ('猫咪', 'cat', '宠物,猫,动物,可爱');
INSERT INTO `video` VALUES ('狗狗', 'dog', '宠物,狗,动物,汪汪');
INSERT INTO `video` VALUES ('大楼', 'build', '大楼,城市,建筑,景色');
INSERT INTO `video` VALUES ('草地', 'grass', '自然,景色,草原,绿色');
INSERT INTO `video` VALUES ('大鹅', 'goose', '动物,家畜,散养,凶猛');
INSERT INTO `video` VALUES ('人', 'people', '人类,摄影,美景');
INSERT INTO `video` VALUES ('很多车', 'manycar', '汽车,城市,生活');
INSERT INTO `video` VALUES ('汽车', 'car', '汽车,奢侈');
 
SET FOREIGN_KEY_CHECKS = 1;

这样表单就创建成功了


相关实践学习
每个IT人都想学的“Web应用上云经典架构”实战
本实验从Web应用上云这个最基本的、最普遍的需求出发,帮助IT从业者们通过“阿里云Web应用上云解决方案”,了解一个企业级Web应用上云的常见架构,了解如何构建一个高可用、可扩展的企业级应用架构。
MySQL数据库入门学习
本课程通过最流行的开源数据库MySQL带你了解数据库的世界。   相关的阿里云产品:云数据库RDS MySQL 版 阿里云关系型数据库RDS(Relational Database Service)是一种稳定可靠、可弹性伸缩的在线数据库服务,提供容灾、备份、恢复、迁移等方面的全套解决方案,彻底解决数据库运维的烦恼。 了解产品详情: https://www.aliyun.com/product/rds/mysql 
相关文章
|
SQL 关系型数据库 MySQL
MySQL执行SQL文件出现【Unknown collation ‘utf8mb4_0900_ai_ci‘】的解决方案
MySQL执行SQL文件出现【Unknown collation ‘utf8mb4_0900_ai_ci‘】的解决方案
MySQL执行SQL文件出现【Unknown collation ‘utf8mb4_0900_ai_ci‘】的解决方案
|
SQL 关系型数据库 MySQL
【MySQL异常解决】MySQL执行SQL文件出现【Unknown collation ‘utf8mb4_0900_ai_ci‘】的解决方案
【MySQL异常解决】MySQL执行SQL文件出现【Unknown collation ‘utf8mb4_0900_ai_ci‘】的解决方案
1608 0
|
SQL 关系型数据库 MySQL
解决:[Err] 1273 - Unknown collation: ‘utf8mb4_0900_ai_ci‘
记录如何结局:[Err] 1273 - Unknown collation: ‘utf8mb4_0900_ai_ci’这个问题
670 1
解决:[Err] 1273 - Unknown collation: ‘utf8mb4_0900_ai_ci‘
|
关系型数据库 MySQL 数据库
nivicat复制mysql数据库[Err] [Dtf] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'错误
问题的原因是两个数据库待转移的表的字符格式不能被被转移数据库识别。例如mysql8的utf8mb4_0900_ai_ci格式再mysql5中就不支持。就需要更改数据库字符编码和各个varchar等字段的编码方式
432 0
nivicat复制mysql数据库[Err] [Dtf] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'错误
|
关系型数据库 MySQL 数据库
mysql报错Unknown collation: utf8mb4_0900_ai_ci
在我们使用高版本mysql的时候,比如mysql8,到mysql5.7 恢复就报错,比如下面这样的错误:
mysql报错Unknown collation: utf8mb4_0900_ai_ci
|
关系型数据库 MySQL 数据库
mysql导入报错 [Err] 1273 – Unknown collation: ‘utf8mb4_0900_ai_ci’
mysql导入报错 [Err] 1273 – Unknown collation: ‘utf8mb4_0900_ai_ci’
mysql导入报错 [Err] 1273 – Unknown collation: ‘utf8mb4_0900_ai_ci’
|
3月前
|
消息中间件 人工智能 安全
云原生进化论:加速构建 AI 应用
本文将和大家分享过去一年在支持企业构建 AI 应用过程的一些实践和思考。
940 49
|
4月前
|
人工智能 安全 中间件
阿里云 AI 中间件重磅发布,打通 AI 应用落地“最后一公里”
9 月 26 日,2025 云栖大会 AI 中间件:AI 时代的中间件技术演进与创新实践论坛上,阿里云智能集团资深技术专家林清山发表主题演讲《未来已来:下一代 AI 中间件重磅发布,解锁 AI 应用架构新范式》,重磅发布阿里云 AI 中间件,提供面向分布式多 Agent 架构的基座,包括:AgentScope-Java(兼容 Spring AI Alibaba 生态),AI MQ(基于Apache RocketMQ 的 AI 能力升级),AI 网关 Higress,AI 注册与配置中心 Nacos,以及覆盖模型与算力的 AI 可观测体系。
1135 52
|
3月前
|
人工智能 运维 Kubernetes
Serverless 应用引擎 SAE:为传统应用托底,为 AI 创新加速
在容器技术持续演进与 AI 全面爆发的当下,企业既要稳健托管传统业务,又要高效落地 AI 创新,如何在复杂的基础设施与频繁的版本变化中保持敏捷、稳定与低成本,成了所有技术团队的共同挑战。阿里云 Serverless 应用引擎(SAE)正是为应对这一时代挑战而生的破局者,SAE 以“免运维、强稳定、极致降本”为核心,通过一站式的应用级托管能力,同时支撑传统应用与 AI 应用,让企业把更多精力投入到业务创新。
564 30
|
3月前
|
设计模式 人工智能 自然语言处理
3个月圈粉百万,这个AI应用在海外火了
不知道大家还记不记得,我之前推荐过一个叫 Agnes 的 AI 应用,也是当时在 WAIC 了解到的。
554 1