[Solved] Is it possible to specify length of "text"
Moderator: General Moderators
[Solved] Is it possible to specify length of "text"
This is something I have always wondered. I am guessing you don't have to specify a length because the length is variable, but how do I specify a maximum length for the text data type?
Last edited by Benjamin on Fri Feb 24, 2006 2:01 pm, edited 1 time in total.
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
The maximum length is defined by the specific type you use.
TINYTEXT / TINYBLOB
255 bytes.
TEXT / BLOB
65535 bytes (64K)
MEDIUMTEXT / MEDIUMBLOB
16,777,215 bytes (16MB)
LONGTEXT / LONGBLOB
4,294,967,295 bytes (4GB)
http://dev.mysql.com/doc/refman/4.1/en/ ... rview.html
TINYTEXT / TINYBLOB
TEXT / BLOB
MEDIUMTEXT / MEDIUMBLOB
LONGTEXT / LONGBLOB
http://dev.mysql.com/doc/refman/4.1/en/ ... rview.html