.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!



Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Max length of of Varchar in sqlserver

Posted By: krishnavenikaladi     Posted Date: February 20, 2010    Points:2   Category :Sql Server
what is max length of Varchar in sqlserver 2005

Responses
Author: Venkat             
Posted Date: February 20, 2010     Points: 5   

Hi,

The maximum storage size for VARCHAR(MAX) is 2^31-1 bytes (2,147,483,647 bytes or 2GB - 1 bytes).

Venkat.

Mark As Answer if this solve your problem
Warm Regards,
Venkat
Author: Lalij Mer             
Posted Date: February 22, 2010     Points: 5   

-->The maximum storage size for VARCHAR(MAX) is 2^31-1 bytes (2,147,483,647 bytes or 2GB - 1 bytes). The storage size is the actual length of data entered + 2 bytes. The data entered can be 0 characters in length. Since each character in a VARCHAR data type uses one byte, the maximum length for a VARCHAR(MAX) data type is 2,147,483,645.

show here mode details

http://www.sql-server-helper.com/sql-server-2005/..%5Cfaq%5Csql-server-2005-varchar-max-p01.aspx

Please Check my answer if you help....
Thank You...

Lalit.


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend