Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
dallasx
- Forum Contributor
- Posts: 106
- Joined: Thu Oct 20, 2005 4:55 pm
- Location: California
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.
-
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.