Skip to content

BLOB and TEXT data types

BLOB

  • BLOB is a large data binary object that can store a variable number.

  • The value of BLOB is a binary string (byte string), corresponding to the binary character set and sorting rules, and the comparison and sorting are based on the numerical values ​​of bytes in the column value.

TEXT

  • TEXT is a non-binary string (string) that is used to store all types of text data. They have character sets outside of binary, and values ​​are sorted and compared based on the sorting rules of the character set.

About BLOB and TEXT

If the value assigned to the BLOB or TEXT column exceeds the maximum length of the column, the portion of the value exceeding the length will be truncated and an alarm will be generated. If the truncated non-space characters, an error occurs (rather than an alarm) and the insertion of values ​​is prohibited. For TEXT, an alarm is always generated when truncating the redundant tail spaces inserted into the value of the TEXT column.