store more than 4000 charecters in a single column in sql server 2008 r2 ??

Hello expert,
how to store more than 4000  charecters  in a single column in sql server 2008 r2??

Who is Participating?
Jim P.Connect With a Mentor Commented:
Well if you want to go to 8000 then change it from nvarchar(4000) to varchar(8000). Or go to varchar(max) as Eric suggested.
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
set its type to varchar(max)
deve_thomosAuthor Commented:
Thanks a lot...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.