Home |
Previous Page | Next Page Data Types > Reporting Standard ODBC Types >
UNIX Only
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=Informix ODBC 3.81 Driver
....
NeedODBCTypesOnly=1
End of UNIX Only
Windows Only
Check
this option under the Advanced tab of the ODBC Administration
for IBM Informix Driver DSN [default is 0].
End of Windows Only
The following table shows how the INFORMIX 9 data
types map to the standard ODBC data types. These types are in
addition to the Informix data types.
- INFORMIX 9
- ODBC
- Blob
- SQL_LONGVARBINARY
- Boolean
- SQL_BIT
- Clob
- SQL_LONGVARCHAR
- Int8
- SQL_BIGINT
- Lvarchar
- SQL_VARCHAR
- Serial8
- SQL_BIGINT
- Multiset
- SQL_C_CHAR/SQL_C_BINARY
- Set
- SQL_C_CHAR/SQL_C_BINARY
- List
- SQL_C_CHAR/SQL_C_BINARY
- Row
- SQL_C_CHAR/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).
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]