The BLOB and TEXT Type
BLOB
-
A
BLOB
is a binary large object that can hold a variable amount of data. -
BLOB
values are treated as binary strings (byte strings). They have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in column values.
TEXT
TEXT
values are treated as nonbinary strings (character strings). They have a character set other than binary, and values are sorted and compared based on the collation of the character set.
About BLOB
and TEXT
If you assign a value to a BLOB
or TEXT
type column that exceeds the maximum length for that column, the portion that exceeds the length will be truncated, and a warning will be generated. If a non-whitespace character is truncated, an error (rather than a warning) occurs, and insertion of the value is prohibited. For TEXT, always generate a warning when trimming excess trailing spaces in values inserted into TEXT columns.