mysql建表Row size too large. The maximum row size for the used table type, not counting BLOBs, is 6553

mysql建表Row size too large. The maximum row size for the used table type, not counting BLOBs, is 6553

mysql建表，报Row size too large. The maximum row size for the used table type, not counting BLOBs, is 6553

现象

CREATE TABLE aaa(id VARCHAR(1000),name VARCHAR(10000),age VARCHAR(5000),gender VARCHAR(390))

原因

我的数据库编码为utf8mb4，数据库设定的varchar长度：（1000+10000+5000+390）*4>65535了，如果是utf8，则是设定的varchar或者其他类型长度乘以3

解决办法

将比较长的字段类型设置成text而不是varchar