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)
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?
No, LongString is the perfect one (if not the only one) for it