web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)
Answered

what is string size of memo

(0) ShareShare
ReportReport
Posted on by 1,128

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

I have the same question (0)
  • Verified answer
    Anton Venter Profile Picture
    20,635 Super User 2026 Season 1 on at

    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.

  • Ann2015 Profile Picture
    1,128 on at

    Thanks!

  • Suggested answer
    Vilmos Kintera Profile Picture
    46,149 on at

    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.

  • SaverioT Profile Picture
    330 on at

    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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=codigo+interno++2986+en+factura+electr%C3%B3nica" - Nested quantifier +.