For storing Boolean values.
Data type |
Values |
Supported by |
---|---|---|
BIT |
0 or 1 |
Sybase IQ and Enterprise |
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.
Adaptive Server Enterprise BIT datatypes only allow 0 or 1 values.