The following table shows the supported conversions between the additional Informix SQL data types for Dynamic Server and the Informix ODBC Driver C data types, including the additional Informix ODBC Driver C data type for Dynamic Server. An X indicates a supported conversion.
| Informix SQL Data Type | Informix ODBC Driver C Data Type (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 | |
| Collection | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| DISTINCT | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| OPAQUE a | X | X | ||||||||||||||
| Row | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Smart large object | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| a 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. | ||||||||||||||||