Character Limits for Data Types

Question

Hi all,
I had just been researching on the different character limits for data types. So from my understanding of text data type, these are the following limits.
Text - 255 characters
Long Text - 4000 characters
Extra Long Text - 64000 characters 
To my knowledge these are the 3 available options for any VARCHAR in record types, I was just wondering if this information is correct, wanting clarification please. 
Couldn't really find a clear answer on the limits.

Note: I believe that for record types, there's a limitation for Extra Long Text, limited to only 3 fields within a record type that's allowed to have the Extra Long Text data type.

shubhama926776 · Accepted Answer

These limits apply to synced records and any text exceeding these limits will be truncated.

You can find this limitation when you configure fields in a record (see below).

I believe that for record types, there's a limitation for Extra Long Text, limited to only 3 fields within a record type that's allowed to have the Extra Long Text data type.

https://docs.appian.com/suite/help/25.3/about-data-sync.html#use-extra-long-text-fields-to-store-large-volumes-of-data

stefanhelzle0001 · Answer

And, keep in mind, that these "characters" are actually bytes. So, if you want to store emojis only, you have to divide the number by 4 as each emoji takes 4 bytes to store.

Sign up

Login with SSO

Login to the community

Login with SSO