The following table shows the supported conversions between the additional Informix SQL data types for GLS and the Informix ODBC Driver C data types. An X indicates a supported conversion.
Only Dynamic Server can convert data to SQL_C_BIT.
| 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 | |
| NCHAR | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |
| NVARCHAR | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |