mysql字符类型长度限制

mysql> create table t1(name char(256)) default charset=utf8;

--ERROR 1074 (42000): Column length too big for column 'name' (max = 255); use BLOB or TEXT instead


mysql> create table t1(name char(255)) default charset=utf8;

--Query OK, 0 rows affected (0.06 sec)


		

mysql> create table t1(name varchar(65532)) default charset=utf8;

--ERROR 1074 (42000): Column length too big for column 'name' (max = 21845); use BLOB or TEXT instead


mysql> create table t1(name varchar(21845)) 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 t1(name varchar(21844)) default charset=utf8;

--Query OK, 0 rows affected (0.07 sec)

		

mysql> create table t1(name varchar(65535));

--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 t1(name varchar(65534));

--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 t1(name varchar(65533));

--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 t1(name varchar(65532));

--Query OK, 0 rows affected (0.08 sec)