I created a *very large* object containing about 20 different Text-Fields.
When saving the object, I get the error:
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.
The messages tells me, that in the current configuration each of the Text-Fields stores 768 bytes inline and then the total allowed 8126 per row is exceeded.
Is there a way to tell Silverstripe to configure some table as innodb ROW_FORMAT = dynamic and keep the object structure?
What happens, if I do this on the database level (mysql) and make Silverstripe rebuild the structure (dev/build after model changes)?
Or maybe, is there any other solution for this problem?
Thanks in advance
and best regards