CODEWITHSUNDEEP
sql-serversql-server-2008
Alan2
Alan2

Reputation: 24572

How many characters can I store in an NVARCHAR(4000) on SQL Server?

I am getting confused. Does the NVARCHAR(4000) refer to the number of characters I can have in that field or do I have to do some conversion for this? I already realize that the NVARCHAR occupies twice as much space per character but I am still not sure how many characters maximum in the 4000.

Upvotes: 1

Views: 7541

Answers (1)

Damien_The_Unbeliever
Damien_The_Unbeliever

Reputation: 239664

nvarchar(4000) can store 4000 UCS-2 characters:

Variable-length Unicode string data. n defines the string length and can be a value from 1 through 4,000.

Upvotes: 5

Related Questions