Syntax Error or Access Rule Violation detected by database (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)

[xiaix]

Okay, I know this question has been asked before, and I know the answer as to why I keep getting this error:

Syntax Error or Access Rule Violation detected by database (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)

when I attempt to add more fields to a table.

However... I'm only at 24,284 and I'm getting this error when I try to add more.

Breakdown:

        I have 32 fields with max length set to 32 characters.   This adds up to 1,024

        I have 76 fields with max length set to 40 characters.   This adds up to 1,840

        I have 84 fields with max length set to 255 characters.   This adds up to 21,420.

Total = 24,284

So... I have max 65,535 available to me and I'm only at 21,420 so far, why do I get the above error when adding more fields!?

[lSurya 24]

Hello David,

Have you find the solution, if yes, can you please share the solution. Even I am facing the same issue?

Thanks in advance.

[gik]

When you reach maximum row size for the used table type you can ask HI Support to get your database upgrade to new version which supports larger row size.

[Suzanne H]

We have the same issue.  We submitted a ticket to Now Support and were told that they could do a hybridization for us but that would only be a temporary solution.  We are faced with reducing row size by deleting unused columns or changing the type.  My concern is that this solution is also temporary and that we'll be faced with this again.

Does anyone have any input?  If you have had this issue, what did you do to solve it?

Thank you!