List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 23 1999 6:59pm
Subject:Why use TINYTEXT or TINYBLOB?
View as plain text  
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/
Thread
Why use TINYTEXT or TINYBLOB?Paul DuBois23 Jun
  • Why use TINYTEXT or TINYBLOB?Michael Widenius28 Jun