Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

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??


Thanks
Thomos
0
deve_thomos
Asked:
deve_thomos
2 Solutions
 
Éric MoreauSenior .Net ConsultantCommented:
set its type to varchar(max)
0
 
Jim P.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.
0
 
deve_thomosAuthor Commented:
Thanks a lot...
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now