BLOB and TEXT Data Types


A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types are

These differ only in the maximum length of the values they can hold.

The TEXT types are

These correspond to the four BLOB types and have the same maximum lengths and storage requirements.

MariaDB starting with 10.2.1

Starting from MariaDB 10.2.1, BLOB and TEXT columns can have a DEFAULT value.


Comments loading...