Additional conversions for Informix
There are supported conversions between the additional HCL Informix® SQL data types for Informix and the HCL Informix ODBC Driver C data types.
The Informix SQL
data types, Collection, DISTINCT, Row, and Smart large object, support
conversions between the following Informix ODBC
driver C data types (fCType):
- SQL_C_BINARY
- SQL_C_BIT
- SQL_C_CHAR
- SQL_C_DATE
- SQL_C_DOUBLE
- SQL_C_FLOAT
- SQL_C_LONG
- SQL_C_SHORT
- SQL_C_SLONG
- SQL_C_SSHORT
- SQL_C_STINYINT
- SQL_C_TIMESTAMP
- SQL_C_TINYINT
- SQL_C_ULONG
- SQL_C_USHORT
- SQL_C_UTINYINT
The Informix SQL data type OPAQUE supports conversion between the SQL_C_BINARY and SQL_C_CHAR ODBC driver C data types (fCType). Use SQL_C_CHAR to access an OPAQUE value in the external format as a string. Use SQL_C_BINARY to access an OPAQUE value in the internal binary format.