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

binary()

The term binary(n) describes a Datatype, or binary datatype. Like all binary datatypes, the datatype binary(n) is also an expansion of Transact-SQL. The datatype binary(n) requires n bytes of storage space. The parameter n can represent values of less or equal 255 (n <= 255).

Using the datatype binary(n)

The maximum length of binary(n) depends on the page size configured for ASE-Server as well as on the locking scheme or "lock scheme" of its tables . If the limits are not known or have to be changed, the commands dbcc serverlimits or lockscheme() might be of help. Independent of the "page size" of the ASE-server binary(n) can be used for binary raw data, which cannot be larger than 16384 bytes.

See also:
bin,
varbinary,
image and
Datatypes.

See also:

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