ASA SQL Reference
  SQL Data Types
    Binary data types

BINARY data type [Binary]

Function 

Binary data of a specified maximum length (in bytes).

Syntax 

BINARY [ ( max-length ) ]

Usage 

The default max-length is 1.

The maximum size allowed is 32767. The BINARY data type is identical to the CHAR data type except when used in comparisons. BINARY values are compared exactly while CHAR values are compared using the collation sequence of the database.

Parameters 

max-length     An integer expression that specifies the maximum length of the expression.

Standards and compatibility 

• SQL/92    Vendor extension.

• Sybase    Adaptive Server Enterprise supports max-length up to 255.

See also 

LONG BINARY data type [BINARY]

VARBINARY data type [BINARY]