Bit data type

Description

For storing Boolean values.

Data type

Values

Supported by

BIT

0 or 1

Sybase IQ and Enterprise

Usage

BIT stores only the values 0 or 1. Inserting any non-zero value into a BIT column stores a 1 in the column. Inserting any zero value into a BIT column stores a 0.

Only the default index type is supported for BIT data.


Compatibility

Adaptive Server Enterprise BIT datatypes only allow 0 or 1 values.