A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: Datatypes: Binary Datatypes

bit

This article describes the ASE datatype "bit". See also: bit, dataunit.

The term bit describes a datatype, i.e. a binary datatype. Like all binary datatypes, the datatype bit is also an expansion of Transact-SQL. It can store values of 1 or 0. The datatype bit requires 1 Byte of storage space, i.e. 8 bit per byte will be stored. NULL values cannot be stored.

Usage of the datatype bit

The datatype bit is defined for columns which can have on of two states (yes or no, on or off).

See also:

Binary Datatypes,
binary(),
image,
varbinary(n).