V2EX = way to explore V2EX 是一个关于分享和探索的地方
Sign Up Now For Existing Member Sign In
MySQL 5.5 Community Server MySQL 5.6 Community Server Percona Configuration Wizard XtraBackup 搭建主从复制 Great Sites on MySQL Percona MySQL Performance Blog Severalnines 推荐管理工具 Sequel Pro phpMyAdmin 推荐书目 MySQL Cookbook
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目 MariaDB Drizzle 参考文档 http://mysql-python.sourceforge.net/MySQLdb.html 
This topic created in 3141 days ago, the information mentioned may be changed or developed.
latin1 字符集, 65532
utf8 字符集, 21844
utf8mb4 字符集, 16128
也就是说如果设定为 utf8mb4 字符集, varchar 最多能存 16128 个字符, 不论是中文还是英文.
(65535-1-2)/1=65532
(65535-1-2)/3=21844
(65535-1-2)/4=16383 !=16128, 不满足这个"公式"
官方文档: https://dev.mysql.com/doc/refman/5.7/en/char.html
The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used.
 | 1 jin7 OP 对了, mysql 版本是 5.7.17, 存储引擎是 innodb |
 | 2 jin7 OP |
 | 3 soli Sep 21, 2017 有用。谢谢。 |
 | 4 iwishing Sep 21, 2017 16383-16128=255 你试试看只有一个 colume，能有多长？ |
| 5 iwishing Sep 22, 2017  1 http://img.vim-cn.com/40/aefbf9e17f48daf8a6c758a1202f4de5a67342.png which is shared among all columns， 所有列都共享这个长度 |
| 6 jin7 OP 我回去试试哈 |
 | 10 mysql Oct 1, 2017 感谢分享 |
Select Language