I'm designing a database for use in a program, and I am worried about
the size ramifications. Basically, I'd like to store text in one of the
database columns; this text will typically be ~a few thousand bytes,
but could conceivably be a few million. If I was to declare the type of
this column as MEDIUM TEXT, this would be big enough to allow for all
sizes of character strings.
However, if I only have a few entries at first that are a few thousand
characters, would the unused space in the cell be padded out to ...