I have a column in the database for storing details abotu the record. Users input large amounts of plain text (usually a paragraph or so). The column data type is set to nvarchar(MAX), but lately we're noticing that some of these text entries are being randomly cut off. I have no idea what could be causing this. I'm not sure if it's user error or I'm doing something wrong. Is there anything I should be doing other than setting the data type to nvarchar(MAX)? They're entering data into this particular column with a multiline textbox with wrap set to true if that matters.
I'm under a bit of pressure over this and could really use some help.