LOB Functions

BIT_TO_BLOB

BIT_TO_BLOB(blob_type_column_or_value)

This function converts BIT or VARYING BIT type into BLOB type.

Parameters:blob_type_column_or_value -- Target column or value to convert
Return type:BLOB

BLOB_FROM_FILE

BLOB_FROM_FILE(file_pathname)

This function read the contents from the file with VARCHAR type data and returns BLOB type data.

Parameters:file_pathname -- the path on the server which DB clients like CAS or CSQL are started
Return type:BLOB
SELECT CAST(BLOB_FROM_FILE('local:/home/cubrid/demo/lob/ces_622/image_t.00001352246696287352_4131')
   AS BIT VARYING) result;

SELECT CAST(BLOB_FROM_FILE('file:/home/cubrid/demo/lob/ces_622/image_t.00001352246696287352_4131')
   AS BIT VARYING) result;

BLOB_LENGTH

BLOB_LENGTH(blob_column)
The length of LOB data stored in BLOB file is returned.
Parameters:clob_column -- The column to get the length of BLOB
Return type:INT

BLOB_TO_BIT

BLOB_TO_BIT(blob_type_column)

This function converts BLOB type to VARYING BIT type.

Parameters:blob_type_column -- Target column to convert
Return type:VARYING BIT

CHAR_TO_BLOB

CHAR_TO_BLOB(char_type_column_or_value)

This function converts CHAR or VARCHAR type into BLOB type.

Parameters:char_type_column_or_value -- Target column or value to convert
Return type:BLOB

CHAR_TO_CLOB

CHAR_TO_CLOB(char_type_column_or_value)

This function converts CHAR or VARCHAR type into CLOB type.

Parameters:char_type_column_or_value -- Target column or value to convert
Return type:CLOB

CLOB_FROM_FILE

CLOB_FROM_FILE(file_pathname)

This function read the contents from the file with VARCHAR type data and returns CLOB type data.

Parameters:file_pathname -- the path on the server which DB clients like CAS or CSQL are started
Return type:CLOB

If you specify the file_pathname as the relative path, the parent path will be the current working directory. For the statement including this function, the query plan is not cached.

SELECT CAST(CLOB_FROM_FILE('local:/home/cubrid/demo/lob/ces_622/image_t.00001352246696287352_4131')
   AS VARCHAR) result;

SELECT CAST(CLOB_FROM_FILE('file:/home/cubrid/demo/lob/ces_622/image_t.00001352246696287352_4131')
   AS VARCHAR) result;

CLOB_LENGTH

CLOB_LENGTH(clob_column)

The length of LOB data stored in CLOB file is returned.

Parameters:clob_column -- The column to get the length of CLOB
Return type:INT

CLOB_TO_CHAR

CLOB_TO_CHAR( clob_type_column [USING charset] )

This function converts CLOB type into VARCHAR type.

Parameters:
  • clob_type_column -- Target column to convert
  • charset -- The character set of string to convert. It can be utf8, euckr or iso88591.
Return type:

VARCHAR