nvarchar (max) maximum length in characters

Question

Hello,

I have the following field on Table:

  Data nvarchar (max) null

I need to save some text and HTML markup on this field.

How many characters can I save in a field of type nvarchar (max)?

Thank you,

Miguel

 

Answer 1

http://msdn.microsoft.com/en-us/library/ms186939.aspx

---

Thanks and regards, Rishabh , Microsoft Community Contributor

Answer 2

It is 2^31-1 bytes :)

J

---

There are 10 type of people. Those who understand binary and those who do not.
My Blog

Answer 3

Variable-length Unicode character data. ncan be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes.

http://msdn.microsoft.com/en-us/library/ms186939.aspx

 

Thanks,

---

Trilok Negi