【转】分享 MySQL 数据库 varchar 到底可以存多少个汉字，多少个英文呢?我们来搞搞清楚

今日在找mysql的utf8和utf8mb4的区别是，看到一篇很不错的文章，看完下来，感觉有点懂了，现将这篇文章抄过来（偷懒，直接以截图的方式copy过来，可以到原文那边看），日后细细回味。

先贴原文出处：分享 MySQL 数据库 varchar 到底可以存多少个汉字，多少个英文呢?我们来搞搞清楚

 

mysql>     CREATE TABLE `str_test` (
->         `id`  tinyint(1)  NOT NULL,
->         `name_chn` varchar(21845) NOT NULL
->     ) ENGINE=InnoDB AUTO_INCREMENT=62974 DEFAULT CHARSET=utf8
-> ;
ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
mysql>     CREATE TABLE `str_test` (
->         `id`  tinyint(1)  NOT NULL,
->         `name_chn` varchar(21844) NOT NULL
->     ) ENGINE=InnoDB AUTO_INCREMENT=62974 DEFAULT CHARSET=utf8
->
->
-> ;
Query OK, 0 rows affected (0.06 sec)

    mysql>     CREATE TABLE `str_test` (
    ->         `id`  tinyint(1)  NOT NULL,
    ->         `name_chn` varchar(32768) NOT NULL
    ->     ) ENGINE=InnoDB AUTO_INCREMENT=62974 DEFAULT CHARSET=gbk
    -> ;
ERROR 1074 (42000): Column length too big for column 'name_chn' (max = 32767); use BLOB or TEXT instead

mysql>     CREATE TABLE `str_test` (
    ->         `id`  smallint(1)  NOT NULL,
    ->         `name_chn` varchar(32766) NOT NULL
    ->     ) ENGINE=InnoDB AUTO_INCREMENT=62974 DEFAULT CHARSET=gbk
    -> ;
ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

 

 

---

---

---

 

 

 

 

https://www.iteye.com/blog/csumissu-1090053