mysql表多个text的字段，出现以下错误，#1118 - Row size too large (> 8126). Changing some column

[tb_609503]

首先感谢解答。
本人有一个表，里面有10多个text的字段，会填很多数据。但是在保存时候出现以下错误，
#1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

请问怎么解决？万分感谢！

[姜小白-]

参考 Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline

[tb_609503]

引用 1 楼 magi1201 的回复:

参考 Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline

这个我看过了，也试过上面的方法，但是我这个表有外键，改不了MyISAM，试过了longtext也不行，还有其他的办法吗？