关于MySQL字符集问题:Specified key was too long; max key length is 767 bytes
来源:互联网 发布:淘宝网主页 编辑:程序博客网 时间:2024/06/05 22:32
今天同步同事的数据库数据。出现了Specified key was too long; max key length is 767 bytes,错误,最后找到原因是因为
原因:MySQL的varchar主键只支持不超过768个字节 或者 768/2=384个双字节 或者 768/3=256个三字节的字段而 GBK是双字节的,UTF-8是三字节的。
我的数据库字符集为utf8,3字节,因此最低因为256;
阅读全文
0 0
- 关于MySQL字符集问题:Specified key was too long; max key length is 767 bytes
- 关于Django出现Specified key was too long; max key length is 767 bytes的解决办法
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- mysql [Err] 1071 - Specified key was too long; max key length is 767 bytes
- MySQL:Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- mysql报错:Specified key was too long; max key length is 767 bytes
- MySQL-001-specified key was too long ; max key length is 767 bytes
- [MySQL] specified key was too long max key length is 767bytes
- mysql: Specified key was too long; max key length is 767 bytes
- mysql Specified key was too long; max key length is 767 bytes
- mysql [42000][1071] Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- mysql:Specified key was too long; max key length is 767 bytes
- Specified key was too long; max key length is 767 bytes问题
- hive执行命令Specified key was too long; max key length is 767 bytes 问题
- 二叉搜索树
- win7 64位TensorFlow1.2.1的安装
- 30分钟学习正则表达式——学习笔记
- win10下载文件夹变成英文了该怎么办?下载文件夹变成英文的修复方法
- The Necklace ——UVA
- 关于MySQL字符集问题:Specified key was too long; max key length is 767 bytes
- python文件操作
- mnist
- html之js数组
- java中关于DecimalFormat四舍五入的用法
- 第九章 JSP标签
- spring入门--spring入门案例
- HashMap源码分析(2)
- 7、C#中的接收用户输入并处理