Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 



BLOB/CLOB

BLOB
  • A type that stores binary data outside the database.
  • The maximum length of BLOB data is the maximum file size creatable in an external storage.
  • In SQL statements, the BLOB type expresses the input and output value in a bit array. That is, it is compatible with the BIT(n) and BIT VARYING(n) types, and only an explicit type change is allowed. If data lengths differ from one another, the maximum length is truncated to fit the smaller one.
  • When converting the BLOB type value to a binary value, the length of the converted data cannot exceed 1GB. When converting binary data to the BLOB type, the size of the converted data cannot exceed the maximum file size provided by the BLOB storage.
CLOB
  • A type that stores character string data outside the database.
  • The maximum length of CLOB data is the maximum file size creatable in an external storage.
  • In SQL statements, the CLOB type expresses the input and output value in a character string. That is, it is compatible with the CHAR(n), VARCHAR(n), NCHAR(n), and NCHAR VARYING(n) types. However, only an explicit type change is allowed, and if data lengths are different from one another, the maximum length is truncated to fit to the smaller one.
  • When converting the CLOB type value to a character string, the length of the converted data cannot exceed 1 GB. When converting a character string to the CLOB type, the size of the converted data cannot exceed the maximum file size provided by the CLOB storage.