Notifications
Announcements
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
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.
Thanks!
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.
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.
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…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Volodya 2
tgudwanski 1
