Hi. I needing to create a SQL table that contain the input fields of the attached image of the form but will have 25 rows instead of the current 12. When the form is submitted it dumps into one SQL table row. When creating the table I receive the "Row size
too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs" error.
divya7
Member
16 Points
20 Posts
not able to insert .. row size too large error
Mar 18, 2012 01:03 AM|LINK
Lannie
Contributor
3738 Points
728 Posts
Re: not able to insert .. row size too large error
Mar 19, 2012 01:25 AM|LINK
show code so forum members can help you.
insufficient information
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: not able to insert .. row size too large error
Mar 19, 2012 01:38 AM|LINK
So you have 12 rows that add up to 65535 bytes? What are your current datatypes and are you sure they need to be as big as they are?