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

Question

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.

Shivanand Arur · Answer

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