Any limitation in the length of text data type

As my understand, if the length of text data type is greater than 2000 in the outsystems, it will set the text field to be nvarchar(max) in MS SQL DB. However, the outsystems will still restrict the input length as you defined. Is it corrected? 

If i define the length text data to be 4000, it will restrict to input 4000 characters.

If I define the length text data to be 90000, it will restrict to input 90000 characters. Any performance impact and memory leakage if the bigger number is defined?


Rahul Sahu wrote:

Hi Jessica,


Read this artical will help you.

https://stackoverflow.com/questions/4378795/sql-performance-is-there-any-performance-hit-using-nvarcharmax-instead-of-nva

https://www.sqlservertutorial.net/sql-server-basics/sql-server-nvarchar/

https://stackoverflow.com/questions/43945645/good-practices-of-sql-server-nvarcharmax-performance


Regards

Rahul Sahu

Hi Rahul,

Thank for your response.

Does outsystems will still restrict the input length as you defined?

Also if i  define the largest value, does it cause the outsystem's bad performance and unexpected error?

Hi Jessica,

Outsystem application. when you define entity attribute and set length like 100

and when you bind it from input widget  and if restrict input 80

it will give you warning not error. 

Like below image 


Regards

Rahul Sahu