Does that answer it?
In most respects, you can regard a TEXT column as a VARCHAR column that can be as big as you like. Similarly, you can regard a BLOB column as a VARCHAR BINARY column. The differences are:
* You can have indexes on BLOB and TEXT columns with MySQL Version 3.23.2 and newer. Older versions of MySQL did not support this.
* There is no trailing-space removal for BLOB and TEXT columns when values are stored, as there is for VARCHAR columns.
* BLOB and TEXT columns cannot have DEFAULT values.