Max string length for MDO

[shaji_chandran]

Hello MII Folks,

MII Version 15.3 SP0

I would like to know what is the maximum length of string type attribute in MDO. When I try to set a length which is more than 4000 I am getting an error. I have attached the screenshot. I am planning to store payload (XML message) within a MDO and 4000 seems to be pretty small. MDO doesn't have XML type attribute as well.

I am creating a MII solution which must be easily portable. So I prefer to use MDO rather database tables to avoid dependencies.

Thanks in advance

Shaji

mdo-error.png

[agentry_src]

I would suggest that if you still desire to have fields larger than 4000, search the MDO help documents.

[eli_dealmeida]

You need to use nvarchar(max), instead of varchar(4000) or varchar(max).

Take a look:

https://docs.microsoft.com/en-us/sql/t-sql/data-types/nchar-and-nvarchar-transact-sql?redirectedfrom...

BR,

Eli Soares De Almeida