Bit Data Type

Use the BIT data type for storing Boolean values.

Data type

Values

Supported by

BIT

0 or 1

SQL Anywhere and Adaptive Server Enterprise

Usage

BIT stores only the values 0 or 1.

Inserting any nonzero 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.