SQL Server 2000 Text Data Type

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
dallasx
Forum Contributor
Posts: 106
Joined: Thu Oct 20, 2005 4:55 pm
Location: California

SQL Server 2000 Text Data Type

Post 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?
ody
Forum Contributor
Posts: 147
Joined: Sat Mar 27, 2004 4:42 am
Location: ManchesterUK

Post by ody »

the text datatype will store a string of 2^31, or 2147483648 characters.
User avatar
dallasx
Forum Contributor
Posts: 106
Joined: Thu Oct 20, 2005 4:55 pm
Location: California

Post 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.
Post Reply