Character type information
The DataBlade
API provides
functions to obtain the following information about a character (CHAR,
VARCHAR, and IDSSECURITYLABEL) data type:
- The data type: its type name (string), type descriptor, or type identifier
- The precision: the maximum number of characters in the data type
The DataBlade
API provides
the following functions to obtain the type and precision of a character
data type.
| Purpose of function | Functions for obtaining the type name, type identifier, or type descriptor of a character data type | Functions for obtaining the precision of a character data type |
|---|---|---|
| For a basic data type | mi_type_typedesc(), mi_type_typename() | mi_type_precision() |
| For a UDR argument | mi_fp_argtype(), mi_fp_setargtype() | mi_fp_argprec(), mi_fp_setargprec() |
| For a UDR return value | mi_fp_rettype(), mi_fp_setrettype() | mi_fp_retprec(), mi_fp_setretprec() |
| For a column | mi_column_type_id(), mi_column_typedesc() | mi_column_precision() |
| For an input parameter in a prepared statement | mi_parameter_type_id(), mi_parameter_type_name() | mi_parameter_precision() |