Home Forums SQL Server 2005 Development Difference between varchar(max) and varchar(8000) RE: Difference between varchar(max) and varchar(8000)

  • Jeff Moden (2/3/2009)


    charlesz (2/2/2009)


    Second, NVarchar(MAX) and Varchar(MAX) can only hold up to 65535 bytes ( The number posted by Gail Shaw was wrong).

    Our product DB-WAN Accel communicates with SQL Server using TDS protocol.

    Charles Zhang

    http://www.speedydb.com

    Lynn Pettis (2/2/2009)


    So, I must agree with Jeff, who and where did you here that so that they may be properly corrected. I see pork chops in someones future!

    And, since this is a form of "forum span", here's the first pork chop... why would anyone in their right mind even consider buying a product from a person who can't even get a grip on the basics of T-SQL... ie. the max values of data types?

    ++1

    I could not have replied any better!


    * Noel