1118 Row Size to Large

Resolve "Row Size Too Large" error when creating a CF database table.

Overview

The error occurs because the total defined column sizes exceed the database's maximum row size limit.
Reduce the size of some columns, particularly by using smaller VARCHAR lengths than the default suggestion, to stay within the row size limit.

Answered
ChronoForms v6
co coughlin 11 Dec, 2017
When attempting to create a table for my form, I get the following error:
1118 Row Size to Large image 1
Any ideas on how to fix this?
Gr GreyHead 12 Dec, 2017
Answer
Hi coughlin,

As is suggested, make some of the columns smaller. ChronoForms suggests VARCHAR(256) but this is often much more than you need. Please see this FAQ

Bob
This topic is locked and no more replies can be posted.