Afficher un message
Vieux 02/09/2007, 18h06   #1
Renito 73
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Lengtht of TEXT data types

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
  Réponse avec citation
 
Page generated in 0,05130 seconds with 9 queries