How to get a form size for a record?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2022 03:43 AM
Hello,
I want to know the size of one record. Let's say I want to know the form size of a change record - CHG0000001
XML import of the record is 132 KB.
I keep getting the error "java.sql.BatchUpdateException: (conn=478024) 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." when I try to save the form.
And what could be the ideal number and Max Length of HTML and string fields present in a form.
Thank you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2022 04:24 AM
Hello,
Just export change record and see the size that's the easiest way no ?
Regards
Regards,
Musab
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2022 04:44 AM
The XML import is 132 KB.
Is that large?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2022 04:45 AM
Nope, it's a small size only, if query is resolved mark my answer as correct and close the thread
Regards,
Musab
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2022 04:56 AM
I get this error message "java.sql.BatchUpdateException: (conn=478024) 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: when trying to save this 132 KB size form after I give some text to a field.