UDF Memo max size?

[Former Member]

Hey guys! I was wondering what's the max size (UserFieldsMD:EditSize) for a UDF Memo type (UserFieldsMD:Type = dbMemo)?

Thanks!

[Former Member · Accepted solution]

The DI SDK Doc says "EditSize applies only when the Type property is set to db_Alpha or db_Numeric" so it doesn't matter for Memo fields. But I'm still wondering as to what's the max size (in chars) of a UDF Memo field?

[AlexGrebennikov · Accepted solution]

Hi Nick!!

SBO_memo-field is originally SQL_ntext-field. And as SQL-Help says "<b>ntext</b> - Variable-length Unicode data with a maximum length of 2pow30 - 1 (1,073,741,823) characters. Storage size, in bytes, is two times the number of characters entered".

hope that is exactly what are you lookin' for

[Former Member]

Thanks for the clarification Alexey!

[AdKerremans]

The maximum size of a udf memo field is 31,000 something. We use 30,000 as a limit.

If you put something bigger in this field, no error or warning is issued.