SQL to C: Boolean
The Boolean HCL OneDB™ ODBC Driver SQL data type is SQL_BIT.
The following table shows the HCL OneDB ODBC
Driver C
data types to which Boolean SQL data can be converted. When HCL OneDB 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 OneDB ODBC Driver ignores the value of cbValueMax for this conversion. HCL OneDB 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 |