You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom Object max row size limitation

Accepted answer
57
Views
3
Comments
edited Jan 26, 2016 4:49PM in General Technical Discussions 3 comments

Content

Hello,

As I understand, custom objects have a max row size data limitation of 32000 bytes.  So, assuming someone is creating a-bunch of text fields at 255 characters storing UTF-8 (max 3 bytes per character) this would equate to:

255 * 3 = 765 bytes per character

32000 / 765 = 41 fields per custom object (approximately).

I know that using text fields at 255 characters is not best practice, just trying to validate the math.

 

Also...

How does the "Long Text" data type come into play?  These are limited to 1 megabyte.  Obviously this exceeds the 32000 byte row size limitation so I'm assuming the data in "Long Text" fields is normalized somehow and stored in a separate table (not counted against the row size limitation)?   If this is the case, technically it should be possible to create a custom object with more "Long Text" type fields than 255 character "Plain Text" type fields, correct?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!