Announcements
No record found.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Sagar Suman 2 Super User 2026 Season 1
Alexey Lekanov 2
