DSN settings for report standard ODBC data types

For UNIX™ and Windows™, you can add the new DSN option NeedODBCTypesOnly.

For UNIX, add a new DSN option NeedODBCTypesOnly under your DSN setting in your odbc.ini file [default is 0]. For example: 
[Informix9]
Driver=/informix/lib/cli/libthcli.so
Description=HCL Informix ODBC Driver
.
NeedODBCTypesOnly=1

For Windows, check this option under the Advanced tab of the ODBC Administration for HCL Informix® Driver DSN [default is 0].

The following table shows how the Informix data types map to the standard ODBC data types.
Table 1. Informix and ODBC data type mapping
Informix ODBC
Bigint SQL_BIGINT
Bigserial SQL_BIGINT
Blob SQL_LONGVARBINARY
Boolean SQL_BIT
Clob SQL_LONGVARCHAR
Int8 SQL_BIGINT
Lvarchar SQL_VARCHAR
Serial8 SQL_BIGINT
Multiset SQL_C_CHAR or SQL_C_BINARY
Set SQL_C_CHAR or SQL_C_BINARY
List SQL_C_CHAR or SQL_C_BINARY
Row SQL_C_CHAR or SQL_C_BINARY
Important:
  • For multiset, set, row, and list data types, the data type is mapped to the defaultUDTFetchType attribute set (SQL_C_CHAR or SQL_C_BINARY).
  • To enable SQL_BIGINT to work correctly with SQLBindCol and SQLBindParameter, you must use SQL_C_UBIGINT (which has a supported data range of 8 byte unsigned integer) and not SQL_C_LONG (which has a supported data range of 4 byte integer).