whats the limit of nvarchar in SQL Server 2014?

Wueest Alois 20

I would like know how many characters can be saved in a nvarchar column in older sql server versions

Accepted answer

Olaf Helper 45,111 Reputation points

2024-10-09T11:02:53.1966667+00:00

The size is as long as you define it, either between 1-4000 chararcters, or max = 2^31.

See https://learn.microsoft.com/en-us/sql/t-sql/data-types/nchar-and-nvarchar-transact-sql?view=sql-server-ver16
Please sign in to rate this answer.
Wueest Alois 20 Reputation points

2024-10-09T11:38:41.6566667+00:00

Thank you very much for the answer.

Erland Sommarskog 112.7K Reputation points MVP

2024-10-09T20:59:19.2166667+00:00

To be precise, you can save 8000 bytes in nvarchar(4000). That is necessarily not 4000 characters. Normal characters from human language takes up two bytes, but more exotic stuff like emojis requires four bytes per character.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

vishwakarma, Suman 0 Reputation points

2024-10-09T11:06:31.7733333+00:00

In SQL Server 2014, The limit of nvarchar is upto 4000 and for nvarchar(max) is upto 2GB
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer