Home Forums Article Discussions Article Discussions by Author Discuss content posted by Carlo Romagnano CASTing RE: CASTing
Aleksandr Furman
Ten Centuries
Points: 1167
More actions
May 27, 2008 at 11:32 am
#820715
About size of nvarchar(max)
I tried this:
declare @C nvarchar(max)
set @C = N'hello' + replicate('-',8000)
print len(@c)
the result was still 4000. Can someone explain why it wasn't more since nvarchar(max) can accept more then 4000