Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
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)