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?
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
Rahul Sahu wrote:
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?
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