Tuesday, June 3, 2008

Varchar(Max) limit of max in Sql2005 ?


While developing one store proc i face problem of varchar(max)

my string was genreated more than 100000 charactes and by default varchar(max) size is 65,536

actual size of any max type is 2^30-1
if you place max text size is 1 then it set to max available size

No comments: