Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 4838
Home > Forums > ASP.NET >

what is the max and min size of varchar data type?

Posted by Deepak625 under ASP.NET on 1/10/2012 | Points: 10 | Views : 2392 | Status : [Member] | Replies : 2
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
what is the max and min size of varchar data type?
and when we should use varchar data type?

deepak

Reply | Reply with Attachment
Alert Moderator 

Responses

Posted by: Rkworlds on: 1/10/2012 [Member] Starter | Points: 25

Up
0
Down
In sql server 2008

max size of varchar data type varchar(max)
min size of varchar data type varchar(0)


In sql server 2005 / 2000

max size of varchar data type varchar(8000)
min size of varchar data type varchar(0)


if text or string formate we can use varchar

If this helps you .
Please "Mark as Answer"

Deepak625, if this helps please login to Mark As Answer. | Alert Moderator
Posted by: Sksamantaray on: 1/10/2012 [Member] Silver | Points: 25

Up
0
Down
More about Sql datatypes
:
http://databases.about.com/od/sqlserver/a/char_string.htm

Thanks,
Sanjay

Deepak625, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response

Latest Posts