SQL to C: Boolean
The Boolean HCL Informix® ODBC Driver SQL data type is SQL_BIT.
The following table shows the HCL Informix
ODBC Driver C
data types to which Boolean SQL data can be converted. When HCL Informix
ODBC Driver converts
Boolean SQL data to character C data, the possible values are 0 and 1.
| fCType | Test | rgbValue | pcbValue | SQLSTATE |
|---|---|---|---|---|
| SQL_C_BINARY | cbValueMax ≤ 1 | Data | 1 | N/A |
| cbValueMax < 1 | Untouched | Untouched | 22003 | |
| SQL_C_BIT | HCL Informix ODBC Driver ignores the value of cbValueMax for this conversion. HCL Informix ODBC Driver uses the size of rgbValue for the size of the C data type. | Data | 1 (This is the size of the corresponding C data type.) |
N/A |
| SQL_C_CHAR | cbValueMax > 1 | Data | 1 | N/A |
| cbValueMax ≤ 1 | Untouched | Untouched | 22003 |