Hello list

I have doubt on TEXT data types... Checking my notes I see these ones:

TINYTEXT/TINYBLOB (2^8) 255 chars
TEXT/BLOB (2^16) 64K chars
MEDIUMTEXT/MEDIUMBLOB (2^24) 16M chars
LONGTEXT/LONGBLOB (2^32) chars

Well, my doubt consist on this... are these FIXED lengths for the text fields 
or they have variable length that may grow up to that as maximum?

I require to store messages of variable length from 1 to 1024 characters, so 
TINYTEXT is too short and TEXT is too large, so I want to know if it they 
have variable length analog to the VARCHAR type and the client program only 
ensures the messages to have 1024 length...

Thanks for your help

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to