【Exception】Column length too big for column 'create_by' (max = 16383); use BLOB or TEXT instead

案发现场

Column length too big for column 'create_by' (max = 16383); use BLOB or TEXT instead

Display width out of range for column 'create_by' (max = 4294967295)

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://dev.mysql.com/doc/refman/5.7/en/char.html

实验测试了一下 mysql 的 varchar 的最大有效长度

MYSQL 5.7 VARCHAR 类型实验