1,122
Can someone help me understand what is the string size memo ?
Is there a limit of how many characters I can enter in Notes EDT field which has string size Memo.
Thank you
Ann
*This post is locked for comments
A memo field like Docuref.Notes is transate to a nvarchar(max) into SQL server; as described in https://msdn.microsoft.com/en-gb/library/ms186939.aspx :
"the maximum storage size is 2^31-1 bytes (2 GB). The storage size, in bytes, is two times the actual length of data entered + 2 bytes."
The max string lenght is approssimativly 1 G.
Blob size is around 4 GB per field if I recall this right.
But since that column cannot be indexed and takes very long time to retrieve, it is generally a good practice not to use and put it on regularly used and transactional tables for performance reasons. I would always place memo fields on newly created, separate tables that are joined by the primary index only for memo storing purposes.
Hi Ann, the length is practically unlimited because it is stored in the database as a BLOB (Binary Large Object). It is not the same a normal string field which has a fixed length in the database.
#1
André Arnaud de Cal...
291,759
Super User 2024 Season 2
#2
Martin Dráb
230,468
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
