varchar datatype - difference in max and 8000

Write New Post |

Search Posts | Answered

Resolved Posts |

Un Answered Posts |

Forums Home | Today's Posts |

Hi Experts,

I have a basic doubt in SQL Server 2005. If we declare a column with varchar(8000) then we can insert upto 8000 characters into that column. If we declare varchar(max) then we can insert upto (2 ^ 31)-1 characters into that column.

My doubt is why we are unable to declare varchar(8001) onwards. varchar datatype supports upto 2^31-1 characters but unable to give varchar(8001).

Pls forgive me for this silly question...

Regards,
T.N.Nagasundar

Reply | Reply with attachment | Alert Moderator

Replies

Jayakumars
Posted on: 9/22/2012 5:53:24 AM

Level: Bronze | Status: [Member] | Points: 25

hi

sql sever 2005 design datatype may be
varchar(8000) if u need varchar(8000)> then use put max after brackets

Mark as Answer if its helpful to you

Regards
Email Id: kumaraspcode2009@gmail.com

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

Nagasundar_Tn
Posted on: 9/22/2012 6:13:58 AM

Level: Starter | Status: [Member] | Points: 25

Hi

Thanks for you response. But my doubt is since varchar supports upto 2 GB of data why I am unable to define varchar(8001). Are there any constraint on it? Pls help me in detail

Regards,
T.N.Nagasundar

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

Jayakumars
Posted on: 9/22/2012 6:17:16 AM

Level: Bronze | Status: [Member] | Points: 25

hi

yes if u can use varchar(max) this is allow large data then move to sql server 2008 also there allow large

Please mark as answer if it helpful to you.

Mark as Answer if its helpful to you

Regards
Email Id: kumaraspcode2009@gmail.com

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

varchar datatype - difference in max and 8000

Replies

Reply - Please login to reply

Latest Posts