London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!
AI OnAI Off
How many characters can LongString contain?
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.
Nov 13, 2018 12:39
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?
Edited,
Nov 13, 2018 12:44
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
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)