Character Data Types

Home | Previous Page | Next Page DataBlade API Overview > Accessing SQL Data Types >

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
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. For more information, see Simple Large Objects.