BLOB is an acronym that stands for a large binary object. It is used to hold a variable amount of data.
There are four types of the BLOB.
The differences among all these are the maximum length of values they can hold.
TEXT is a case-insensitive BLOB. TEXT values are non-binary strings (character string). They have a character set, and values are stored and compared based on the collation of the character set.
There are four types of TEXT.