Loading

why I am unable to define varchar(8001) in sql server 2008

Nagasundar Nagarajan

14y2.2k

Hi Experts,

I have a basic doubt. Since varchar(max) supports upto 2 GB data, why I am unable to define varchar(8001). If I have 10000 characters in a column, why should I go for varchar(max), why can't I declare varchar(10000).

Though varchar allocates the memory dynamically, why I am unable to define greater then 8000.

Please give me complete explanation....

Regards,
T.N.Nagasundar.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Shivanand Arur14y ago
Hey, Basically Varchar(numeric value) can store upto 8000 characters only... whereas Varchar(Max) can store upto 2GB of data ie(2 147 483 647 characters). That is why it does not allows you to move ahead with Varchar(8001) or Varchar(10000).

Check out this article... This will help you.

http://stackoverflow.com/questions/3682821/difference-between-varchar500-vs-varcharmax-in-sql-server

If my answer has helped you, then please mark it as ACCEPTED