I'm curious about something.
VARCHAR(255) BINARY and TINYBLOB both have a maximum length of 255
characters and are case sensitive.
Similarly, VARCHAR(255) and TINYTEXT both have a maximum length of 255
characters and are case insensitive.
However, BLOB/TEXT columns cannot have NULL values, they cannot be
indexed, and they cannot have default values. Given the choices above,
when would you ever *not* choose VARCHAR(255) and VARCHAR(255) BINARY
over TINYBLOB/TINYTEXT?
There isn't any trailing space removal for BLOB/TEXT values when you
store them. If you need that, then you might choose TINYBLOB/TINYTEXT,
I suppose.
Are there any other reasons?
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
