Sql server nvarchar size?

Question

I have to store maximum of 5000 character in sql server. Which one I can use to achieve this?

Should I use,

nvarchar(5000);
or 
nvarchar(max);

Possible duplicate of [Implications of nvarchar (50) vs nvarchar (max)](http://stackoverflow.com/questions/20229441/implications-of-nvarchar-50-vs-nvarchar-max) — MusicLovingIndianGirl, Aug 05 '16 at 07:31
Since you cannot declare an [`nvarchar(5000)`](https://msdn.microsoft.com/en-GB/library/ms186939.aspx), I'd recommend using the one that's valid. — Damien_The_Unbeliever, Aug 05 '16 at 07:32
check this, https://www.simple-talk.com/sql/database-administration/whats-the-point-of-using-varchar(n)-anymore/ — Jatin Patel, Aug 05 '16 at 07:32
@MusicLovingIndianGirl - it's not exactly a duplicate since that question at least was comparing two options that are possible. — Damien_The_Unbeliever, Aug 05 '16 at 07:33

score 2 · Answer 1 · answered Aug 05 '16 at 07:33

2

nvarchar has a maximum (declareable) length of 4000. So since you want to store more than 4000 characters, you will have to use nvarchar(max).

answered Aug 05 '16 at 07:33

Adwaenyth

1 Answers1