SQL to C: Bit

The identifier for the bit ODBC SQL data type is:

SQL_BIT

The following table shows the ODBC C data types to which bit SQL data may be converted. For an explanation of the columns and terms in the table, see “Converting Data from SQL to C Data Types.”

C type identifier

Test

*TargetValuePtr

*StrLen_or _IndPtr

SQL- STATE

SQL_C_CHAR

BufferLength > 1 BufferLength <= 1

Data Undefined

1 Undefined

n/a 22003

SQL_C_STINYINT SQL_C_UTINYINT SQL_C_TINYINT SQL_C_SBIGINT SQL_C_UBIGINT SQL_C_SSHORT SQL_C_USHORT SQL_C_SHORT SQL_C_SLONG SQL_C_ULONG SQL_C_LONG SQL_C_FLOAT SQL_C_DOUBLE SQL_C_NUMERIC

None [a]

Data

Size of the C data type

n/a

SQL_C_BIT

None [a]

Data

1 [b]

n/a

SQL_C_BINARY

BufferLength >= 1 BufferLength < 1

Data Undefined

1 Undefined

n/a 22003

[a] The value of BufferLength is ignored for this conversion. The driver assumes that the size of *TargetValuePtr is the size of the C data type. [b] This is the size of the corresponding C data type.

When bit SQL data is converted to character C data, the possible values are “0” and “1”.