December 6, 2007 at 11:44 am
what is the max possible characters for varchar data type?
is it just 8000 as sql server 2000 does?
December 6, 2007 at 11:46 am
2 Gig in '05
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 11:49 am
I wud like to know in number of characters
December 6, 2007 at 12:01 pm
That would be 2,147,483,646 characters + 2 bytes for the length.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 6, 2007 at 12:16 pm
OR 1,073,741,823 for NVARCHAR + 2 Bytes for the length.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 7, 2007 at 1:26 am
Note that that's for varchar(max) or nvarchar(max) The largest number that you can use to define a varchar is 8000 (as in varchar(8000)) and 4000 for nvarchar (nvarchar(4000))
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply