[arrezes]

I've been figuring why this is happening. A field in my form is to register a description of a task. The maximum length of the field would be less then hundred. Therefore, the table column which will hold this is of type nvarchar(100). But when I checked the table after the input, the description was truncated.

why is this happening? is it got to do with the column type or perhaps anything else?

[arrezes]

Hi,

I found the answer myself. I change the column datatype to varchar(MAX) but I forgot to change the stored procedure statement to reflex the changes that I made to the table accordingly.