Insert with column defined as nvarchar(max) is truncating data

[sarchibald-mdsol]

We have an application that is inserting character data into a column defined as nvarchar(max) (SQL Server).

It seems that our data is getting truncated when very long strings are being used for the value. The data is being truncated at about 8000 characters.

Is there a column attribute that needs to be added to the class definition to allow the data to be inserted without truncation?

[tbasallo]

Have you looked at the executed T-SQL to see what parameter is getting passed in? I have never had an issue with this setting.

You can use SQL Profiler to see the final/actual SQL executed.