C to SQL: Bit

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

The following table shows the IBM 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

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

IBM 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. IBM Informix ODBC Driver uses the size of rgbValue for the size of the Boolean C data type.