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.
Thanks!
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Guy Terry 2 Moderator
Martin Dráb 2 Most Valuable Professional
Community Member 2
