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.

Shubham Aware · 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). 
 yongj783799 said: 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

Stefan Helzle · 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.

Character Limits for Data Types

Top Replies