Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
Informix® ODBC Driver GuideThe Informix® ODBC Driver Programmer's Manual serves as a user guide and reference for Informix® ODBC Driver, which is the Informix® implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
Data typesThese topics contain information about the data types that are supported by Informix® ODBC Driver.
Convert dataThe word convert is used in this section in a broad sense; it includes the transfer of data from one storage location to another without a conversion in data type.
Convert data from SQL to CWhen you call SQLExtendedFetch, SQLFetch, or SQLGetData, Informix® ODBC Driver retrieves data from a data source.
Default C data typesYou can specify the SQL_C_DEFAULT for different functions so that Informix® ODBC Driver uses the C data type.
Standard default C data typesThere is default C data type for each Informix® ODBC Driver SQL data type.

Standard default C data types

There is default C data type for each Informix® ODBC Driver SQL data type.

For each Informix ODBC Driver SQL data type, the following table shows the default C data type.


Informix ODBC driver SQL data type (fSqlType)	Default Informix ODBC driver C data type (fCType)
SQL_BIGINT	SQL_C_CHAR
SQL_BIT	SQL_C_BITS
SQL_CHAR	SQL_C_CHAR
SQL_DATE	SQL_C_DATE
SQL_DECIMAL	SQL_C_CHAR
SQL_DOUBLE	SQL_C_DOUBLE
SQL_INTEGER	SQL_C_SLONG
SQL_LONGVARBINARY	SQL_C_BINARY
SQL_LONGVARCHAR	SQL_C_CHAR
SQL_NUMERIC	SQL_C_NUMERIC
SQL_REAL	SQL_C_FLOAT
SQL_SMALLINT	SQL_C_SSHORT
SQL_TIMESTAMP	SQL_C_TIMESTAMP
SQL_VARCHAR	SQL_C_CHARS

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.