Character data types
The DataBlade®
API supports
the following data types that can hold character data in a DataBlade
API module.
| DataBlade API character data type | Description | SQL character data type |
|---|---|---|
| mi_char1 | One-byte character | None |
| mi_unsigned_char1 | Unsigned one-byte character | None |
| mi_char, mi_string | Character string or array | CHAR, VARCHAR, NCHAR, NVARCHAR, IDSSECURITYLABEL |
| mi_lvarchar | Varying-length structure to hold varying-length character data | LVARCHAR |
| MI_LO_HANDLE | LO handle to a smart large object that holds character data | CLOB |
Tip: The database server also supports the TEXT
data type for character data. It stores TEXT character data as a simple
large object. However, the DataBlade
API does
not directly support simple large objects.