I am trying to enter some text in multiline text box. The table the holds the data entered here is set to nvarchar(max). Still it errors out when i try to enter even two lines. Plzzzzzzzzzzzzzzzzzzzzz Help:injured:
what’s the error you’re getting?
Unless there’s something weird in your code, chances are the nvarchar(max) is not the problem. I agree with chieftain, we need to see the error and probably some code too.
Yes, we definitely need to see code and errors. On a side note, I would suggest using varchar(MAX) instead of nvarchar(MAX). nvarchar pads its contents to fill it, where varchar does not
nvarchar pads its contents to fill it, where varchar does not
I think you may be confused with char (or nchar) which is a fixed length string and pads its contents to fit.
nvarchar does use up twice the space of varchar though, so if you do not need unicode data varchar will suffice. Although in this case (a user entering data into a text box) I would go with nvarchar.
More info: http://msdn.microsoft.com/en-us/library/ms186939.aspx
My apologies. You are right. It is the unicode character extra data that takes up double space. If your site is in english only, it is generally ok to user varchar, I very rarely run into problems with it
Please paste here your code and error also, this should not be a problem while using nvarchar(max).