Simple large objects
The DataBlade® API does not provide direct support for simple large objects. Therefore, it cannot directly access TEXT and BYTE columns. However, the database server provides the following cast functions between simple and smart large objects.
| Type conversion | SQL cast function |
|---|---|
| From the TEXT data type to the CLOB data type | TextToClob() |
| From the BYTE data type to the BLOB data type | ByteToBlob() |
C UDRs can accept TEXT data as arguments because the database server passes all character data in the mi_lvarchar data type. C UDRs can also accept BYTE data as long as they declare and handle this data as a smart large object. The database server converts the BYTE data to BLOB data when it passes this data to the UDR.