MQSQL TEXT and LONGTEXT: are they dynamic in space?

[Ali_baba]

Hello,

I have a technical question. If I declare TEXT and/or LONGTEXT, and if I input a sentece (e.g, hello! I am here) then what happens?

Will the rest of the space be wasted (like in CHAR) or values are stored using only as many characters as are needed (like in VARCHAR)

If not then should I use BLOB? I don't want to waste the space because of computing departnemt is quite antsy about it.

[rincewind456]

Read the Manual for blob/text differences then read the Manual for the storage requirements.