You need to sign in to do that
Don't have an account?
MJ Kahn / OpFocus
Data limit for rich/long text fields
The help for "Using Rich Text Area Fields" (https://na5.salesforce.com/help/doc/en/fields_using_rich_text_area.htm) says:
- There are no limits to the number of rich text area and long text area fields that an object can contain, although your Edition's limit for the total number of custom fields allowed on an object, regardless of field type, applies. Each object can contain a total of 1.6 million characters across long text area and rich text area fields. The default character limit for long text area and rich text area fields is 32,768 characters. A long text area or rich text area field needs to contain at least 256 characters.
Does this mean that a single record can have at most 1.6 million characters in rich/long text fiels, or that all the rich/long data for an entire object can't exceed 1.6 million?
You are currently using 53,768 out of 1,638,400 characters on this object. You have 1,584,632 additional characters to allocate to this field.
53,768 is currently used in this Object,
1,638,400 is the whole limit,
1,584,632 is available for use,
but the Max of each long for rich text field is 32,768.
All Answers
You are currently using 53,768 out of 1,638,400 characters on this object. You have 1,584,632 additional characters to allocate to this field.
53,768 is currently used in this Object,
1,638,400 is the whole limit,
1,584,632 is available for use,
but the Max of each long for rich text field is 32,768.
But yes... this is the limit for Each Record, not for all records for a given object...
The limit is imposed on the definition of the object itself (while creating the object definition) even if there are no records in it at all you'll still it this limit if you add to many long fields.
Thanks, Jia. You're right - I should have tested it myself.
IMHO, the wording in the documentation is a bit confusing:
Each object can contain a total of 1.6 million characters across long text area and rich text area fields
It implies (or at least, it's possible to infer) that the limit is on the total number of characters that can be stored in these fields across all records for the object. Another way to word this might be:
If you add the maximum possible lengths for all the long text area and rich text area field definitions for a single object, the maximum allowed total is 1.6 million characters.
Thanks for the replies!
Is there any way that we can upload the data through the data loader that is having data more than the size of the field in the salesforce. I have a rich/long text area in the salesforce with the maximum size of the field but I am having some records for that field that exceeds the maximum size of the rich text area. Any held is appreciable and thanks in advance.
Assume I create a rich text field and allow 1600 characters and fill that field with 1600 characters.
Does that mean from this division, 1,600,000 / 1600, that I can:
1. create 1000 more rich text fields in the object - (of course exceeding the field limit, but this is to illustrate the meaning)
2. create only 1000 records for this object.
https://success.salesforce.com/answers?id=9063A000000p62U
Thank you Sunil Sarilla (https://success.salesforce.com/profile?u=0053000000AJ82F" target="_blank).