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 C to SQLWhen you call SQLExecute or SQLExecDirect, Informix® ODBC Driver retrieves the data for parameters that are bound with SQLBindParameter from storage locations in the application.
C to SQL: BitThe bit Informix® ODBC Driver C data type is SQL_C_BIT.

C to SQL: Bit

The bit Informix® ODBC Driver C data type is SQL_C_BIT.

The following table shows the Informix ODBC Driver SQL data types to which bit C data can be converted.


fSqlType	Test	SQLSTATE
SQL_BIGINT SQL_DECIMAL SQL_DOUBLE SQL_INTEGER SQL_REAL SQL_SMALLINT	None	N/A
SQL_BIT	None	N/A
SQL_CHAR SQL_LONGVARCHAR SQL_VARCHAR	None	N/A

Informix ODBC Driver ignores the value that the pcbValue argument of SQLBindParameter points to and the value of the cbValue argument of SQLPutData when it converts data from the Boolean C data type. Informix ODBC Driver uses the size of rgbValue for the size of the Boolean C data type.

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.