Don't miss out Virtual Happy Hour this Friday (April 26).
Try our conversational search powered by Generative AI!
AI OnAI Off
Don't miss out Virtual Happy Hour this Friday (April 26).
LongString is stored as NVARCHAR(MAX), which is 2GB maximum. Since each character is 2 bytes in length so you get ~ 1 Billion characters maximum.
But I doubt you would want or should have a property that long. But a few KB should be fine.
I see :-)
I need to store a meta field of text of up to 5 KB. Is there a better data type than LongString for that purpose?
I have learned that ShortString (MetaDataType) can hold strings of up to 512 characters.
But what about LongString - how many characters can this data type hold?
(it doesn't seem to be documented anywhere)