The input and output support functions can call the following DataBlade
API functions
to convert the atomic C data types within the server internal representation
of the opaque data type between their external (text) and internal
(binary) representations.
Table 1. Input and output DataBlade
API support
functions for date and date/time data| Type of data |
The streamwrite() support function |
The streamread() support function |
|---|
| DATE data |
mi_string_to_date() |
mi_date_to_string() |
| DATETIME data |
mi_string_to_datetime() |
mi_datetime_to_string() |
| INTERVAL data |
mi_string_to_interval() |
mi_interval_to_string() |
Table 2. Input and output DataBlade
API support
functions for integer data| Type of data |
The streamwrite() support function |
The streamread() support function |
|---|
| SMALLINT data (two-byte integers) |
rstoi(), atoi() |
|
| INTEGER data (four-byte integers) |
rstol(), atol() |
|
| INT8 data (eight-byte integers) |
ifx_int8cvasc() |
ifx_int8toasc() |
Table 3. Input and output DataBlade
API support
functions for fixed-point and floating-point data| Type of data |
The streamwrite() support function |
The streamread() support function |
|---|
| DECIMAL data (fixed-point and floating-point) |
mi_string_to_decimal() |
mi_decimal_to_string() |
| MONEY data |
mi_string_to_money() |
mi_money_to_string() |
| SMALLFLOAT data |
atof() |
|
| FLOAT data |
rstod() |
|
Table 4. Input and output DataBlade
API support
functions for other data| Type of data |
The streamwrite() support function |
The streamread() support function |
|---|
| Character data, Varying-length data |
mi_string_to_lvarchar() |
mi_lvarchar_to_string() |
| LO handle (smart large objects) |
mi_lo_from_string() |
mi_lo_to_string() |
Most DataBlade
API functions
that convert between text and binary representations recognize the
end-user formats for data in a locale-specific format. For more information
about how to internationalize a C UDR, see Internationalization of DataBlade API modules (GLS).