Forums
This topic is locked
varchar length?
Posted 06 Jun 2002 00:55:36
1
has voted
06 Jun 2002 00:55:36 chris espino posted:
SQL Server 2000it says that the limit for VarChar is 8000 lengths.
would that be alphanumeric characters?
by bits?
thanks in advance!
Replies
Replied 06 Jun 2002 01:56:13
06 Jun 2002 01:56:13 Owen Eastwick replied:
It's 8000 characters, basically anything you can find on your keyborad.
12345 = 5 characters
seven = 5 characters
%$&*@ = 5 charcaters
If you need more than 8000 use the <b>text</b> datatype, maximum 2,147,483,647 characters.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
12345 = 5 characters
seven = 5 characters
%$&*@ = 5 charcaters
If you need more than 8000 use the <b>text</b> datatype, maximum 2,147,483,647 characters.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo