devbox
知新_RL
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Unknown collation: ‘utf8mb4_0900_ai_ci‘_unknown collation: 'utf8mb4 0900 ai ci

作者：知新_RL | 2024-06-01 10:31:20

赞

踩

unknown collation: 'utf8mb4 0900 ai ci

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

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

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

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

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

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

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

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

  1. /*
  2.  Navicat Premium Data Transfer
  3.  
  4.  Source Server         : local
  5.  Source Server Type    : MySQL
  6.  Source Server Version : 80029
  7.  Source Host           : localhost:3306
  8.  Source Schema         : ymzting
  9.  
  10.  Target Server Type    : MySQL
  11.  Target Server Version : 80029
  12.  File Encoding         : 65001
  13.  
  14.  Date: 07/05/2023 17:36:14
  15. */
  16.  
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  19.  
  20. -- ----------------------------
  21. -- Table structure for comment
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `comment`;
  24. CREATE TABLE `comment`  (
  25.   `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  26.   `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  27.   `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  28.   `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  29.   `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  30.   `isuse` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
  31. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  32.  
  33. -- ----------------------------
  34. -- Records of comment
  35. -- ----------------------------
  36. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕！！！！！！！！！！', '0.00', '#000000', '0');
  37. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕1', '0.00', '#B42020', '0');
  38. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕2', '0.00', '#52C827', '0');
  39. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕3', '0.00', '#8311A0', '0');
  40. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '0.00', '#DD1919', '0');
  41. INSERT INTO `comment` VALUES ('dog', 'ymzting', '', '0.00', '#000000', '0');
  42. INSERT INTO `comment` VALUES ('dog', 'ymzting', '有时间的弹幕', '8.712107', '#000000', '0');
  43. INSERT INTO `comment` VALUES ('dog', 'ymzting', '发送弹幕', '4.633285', '#000000', '0');
  44. INSERT INTO `comment` VALUES ('dog', 'ymzting', '1111', '12.672615', '#000000', '0');
  45. INSERT INTO `comment` VALUES ('dog', 'ymzting', 'wwww', '14.069479', '#9A1919', '0');
  46. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕', '1.76306', '#000000', '0');
  47. INSERT INTO `comment` VALUES ('dog', 'ymzting', 'websocket', '2.344148', '#000000', '0');
  48. INSERT INTO `comment` VALUES ('dog', 'ymzting', '111', '3.385441', '#000000', '0');
  49. INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '5.381284', '#000000', '0');
  50. INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '13.613529', '#000000', '0');
  51. INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '2.407239', '#000000', '0');
  52. INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '5.256298', '#000000', '0');
  53. INSERT INTO `comment` VALUES ('build', 'ymzting', '1111', '2.059521', '#000000', '0');
  54. INSERT INTO `comment` VALUES ('build', 'ymzting', '11112222', '8.389185', '#000000', '0');
  55. INSERT INTO `comment` VALUES ('build', 'ymzting', '测试', '2.234286', '#000000', '0');
  56. INSERT INTO `comment` VALUES ('build', 'ymzting', '', '0', '#000000', '0');
  57. INSERT INTO `comment` VALUES ('build', 'ymzting', '33333', '3.96462', '#782D2D', '0');
  58. INSERT INTO `comment` VALUES ('build', 'ymzting', '3254524', '2.795794', '#000000', '0');
  59. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '0.83545', '#000000', '0');
  60. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '7.72843', '#000000', '0');
  61. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '10.960832', '#000000', '0');
  62. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '13.756024', '#000000', '0');
  63. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '15.708912', '#000000', '0');
  64. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.765993', '#000000', '0');
  65. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '2.432202', '#C50B0B', '0');
  66. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '6.952991', '#4429AF', '0');
  67. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.168342', '#000000', '0');
  68. INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '2.505749', '#000000', '0');
  69. INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '0', '#000000', '0');
  70. INSERT INTO `comment` VALUES ('grass', 'ymzting', 'wwww', '4.389952', '#000000', '0');
  71. INSERT INTO `comment` VALUES ('grass', 'ymzting', '测试能完结了吗', '3.683333', '#000000', '0');
  72.  
  73. -- ----------------------------
  74. -- Table structure for user
  75. -- ----------------------------
  76. DROP TABLE IF EXISTS `user`;
  77. CREATE TABLE `user`  (
  78.   `id` int(0) NOT NULL AUTO_INCREMENT,
  79.   `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  80.   `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  81.   `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  82.   `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  83.   `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  84.   PRIMARY KEY (`id`) USING BTREE
  85. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  86.  
  87. -- ----------------------------
  88. -- Table structure for video
  89. -- ----------------------------
  90. DROP TABLE IF EXISTS `video`;
  91. CREATE TABLE `video`  (
  92.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  93.   `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  94.   `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
  95. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
  96.  
  97. -- ----------------------------
  98. -- Records of video
  99. -- ----------------------------
  100. INSERT INTO `video` VALUES ('猫咪', 'cat', '宠物，猫，动物，可爱');
  101. INSERT INTO `video` VALUES ('狗狗', 'dog', '宠物，狗，动物，汪汪');
  102. INSERT INTO `video` VALUES ('大楼', 'build', '大楼，城市，建筑，景色');
  103. INSERT INTO `video` VALUES ('草地', 'grass', '自然，景色，草原，绿色');
  104. INSERT INTO `video` VALUES ('大鹅', 'goose', '动物，家畜，散养，凶猛');
  105. INSERT INTO `video` VALUES ('人', 'people', '人类，摄影，美景');
  106. INSERT INTO `video` VALUES ('很多车', 'manycar', '汽车，城市，生活');
  107. INSERT INTO `video` VALUES ('汽车', 'car', '汽车，奢侈');
  108.  
  109. SET FOREIGN_KEY_CHECKS = 1;

更换的表单

  1. /*
  2.  Navicat Premium Data Transfer
  3.  
  4.  Source Server         : local
  5.  Source Server Type    : MySQL
  6.  Source Server Version : 80029
  7.  Source Host           : localhost:3306
  8.  Source Schema         : ymzting
  9.  
  10.  Target Server Type    : MySQL
  11.  Target Server Version : 80029
  12.  File Encoding         : 65001
  13.  
  14.  Date: 07/05/2023 17:36:14
  15. */
  16.  
  17. SET NAMES utf8;
  18. SET FOREIGN_KEY_CHECKS = 0;
  19.  
  20. -- ----------------------------
  21. -- Table structure for comment
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `comment`;
  24. CREATE TABLE `comment`  (
  25.   `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  26.   `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  27.   `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  28.   `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  29.   `color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  30.   `isuse` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
  31. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  32.  
  33. -- ----------------------------
  34. -- Records of comment
  35. -- ----------------------------
  36. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕！！！！！！！！！！', '0.00', '#000000', '0');
  37. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕1', '0.00', '#B42020', '0');
  38. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕2', '0.00', '#52C827', '0');
  39. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕3', '0.00', '#8311A0', '0');
  40. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '0.00', '#DD1919', '0');
  41. INSERT INTO `comment` VALUES ('dog', 'ymzting', '', '0.00', '#000000', '0');
  42. INSERT INTO `comment` VALUES ('dog', 'ymzting', '有时间的弹幕', '8.712107', '#000000', '0');
  43. INSERT INTO `comment` VALUES ('dog', 'ymzting', '发送弹幕', '4.633285', '#000000', '0');
  44. INSERT INTO `comment` VALUES ('dog', 'ymzting', '1111', '12.672615', '#000000', '0');
  45. INSERT INTO `comment` VALUES ('dog', 'ymzting', 'wwww', '14.069479', '#9A1919', '0');
  46. INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕', '1.76306', '#000000', '0');
  47. INSERT INTO `comment` VALUES ('dog', 'ymzting', 'websocket', '2.344148', '#000000', '0');
  48. INSERT INTO `comment` VALUES ('dog', 'ymzting', '111', '3.385441', '#000000', '0');
  49. INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '5.381284', '#000000', '0');
  50. INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '13.613529', '#000000', '0');
  51. INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '2.407239', '#000000', '0');
  52. INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '5.256298', '#000000', '0');
  53. INSERT INTO `comment` VALUES ('build', 'ymzting', '1111', '2.059521', '#000000', '0');
  54. INSERT INTO `comment` VALUES ('build', 'ymzting', '11112222', '8.389185', '#000000', '0');
  55. INSERT INTO `comment` VALUES ('build', 'ymzting', '测试', '2.234286', '#000000', '0');
  56. INSERT INTO `comment` VALUES ('build', 'ymzting', '', '0', '#000000', '0');
  57. INSERT INTO `comment` VALUES ('build', 'ymzting', '33333', '3.96462', '#782D2D', '0');
  58. INSERT INTO `comment` VALUES ('build', 'ymzting', '3254524', '2.795794', '#000000', '0');
  59. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '0.83545', '#000000', '0');
  60. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '7.72843', '#000000', '0');
  61. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '10.960832', '#000000', '0');
  62. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '13.756024', '#000000', '0');
  63. INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '15.708912', '#000000', '0');
  64. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.765993', '#000000', '0');
  65. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '2.432202', '#C50B0B', '0');
  66. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '6.952991', '#4429AF', '0');
  67. INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.168342', '#000000', '0');
  68. INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '2.505749', '#000000', '0');
  69. INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '0', '#000000', '0');
  70. INSERT INTO `comment` VALUES ('grass', 'ymzting', 'wwww', '4.389952', '#000000', '0');
  71. INSERT INTO `comment` VALUES ('grass', 'ymzting', '测试能完结了吗', '3.683333', '#000000', '0');
  72.  
  73. -- ----------------------------
  74. -- Table structure for user
  75. -- ----------------------------
  76. DROP TABLE IF EXISTS `user`;
  77. CREATE TABLE `user`  (
  78.   `id` int(0) NOT NULL AUTO_INCREMENT,
  79.   `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  80.   `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  81.   `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  82.   `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  83.   `role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  84.   PRIMARY KEY (`id`) USING BTREE
  85. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  86.  
  87. -- ----------------------------
  88. -- Table structure for video
  89. -- ----------------------------
  90. DROP TABLE IF EXISTS `video`;
  91. CREATE TABLE `video`  (
  92.   `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  93.   `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  94.   `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
  95. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  96.  
  97. -- ----------------------------
  98. -- Records of video
  99. -- ----------------------------
  100. INSERT INTO `video` VALUES ('猫咪', 'cat', '宠物，猫，动物，可爱');
  101. INSERT INTO `video` VALUES ('狗狗', 'dog', '宠物，狗，动物，汪汪');
  102. INSERT INTO `video` VALUES ('大楼', 'build', '大楼，城市，建筑，景色');
  103. INSERT INTO `video` VALUES ('草地', 'grass', '自然，景色，草原，绿色');
  104. INSERT INTO `video` VALUES ('大鹅', 'goose', '动物，家畜，散养，凶猛');
  105. INSERT INTO `video` VALUES ('人', 'people', '人类，摄影，美景');
  106. INSERT INTO `video` VALUES ('很多车', 'manycar', '汽车，城市，生活');
  107. INSERT INTO `video` VALUES ('汽车', 'car', '汽车，奢侈');
  108.  
  109. SET FOREIGN_KEY_CHECKS = 1;

 这样表单就创建成功了

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/知新_RL/article/detail/657290
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号