Page 1 of 1

SQL Server 2000 Text Data Type

Posted: Tue Nov 29, 2005 2:28 pm
by dallasx
This is probably an easy question to answer but I can't find any direct answer.

What exactly is the TEXT data type, what does the length mean (ex. 16), and how many characters will it store?

Posted: Tue Nov 29, 2005 4:13 pm
by ody
the text datatype will store a string of 2^31, or 2147483648 characters.

Posted: Tue Nov 29, 2005 4:17 pm
by dallasx
ody wrote:the text datatype will store a string of 2^31, or 2147483648 characters.
Regardless of the length or does the length matter?

The reason I ask is because in this table I'm working with it has 16 as a length.