Reference Manual
CHAPTER 7. SQL Data Types
For storing binary data, including images and other information that is not interpreted by the database.
BINARY data type [Binary]Binary data of a specified maximum length (in bytes).
BINARY [ ( max-length ) ]
The default max-length is 1.
The maximum size allowed is 32,767. The BINARY data type is identical to the CHAR data type except when used in comparisons. BINARY values will be compared exactly while CHAR values are compared without respect to upper/lower case unless the database is defined as case-sensitive or accented characters.
max-length An integer expression that specifies the maximum length of the expression.
SQL/92 Vendor extension.
Sybase Adaptive Server Enterprise supports max-length up to 255.
LONG BINARY data type [BINARY]Arbitrary length binary data. The maximum size is limited by the maximum size of the database file (currently 2 gigabytes).
LONG BINARY
The maximum size is limited by the maximum size of the database file (currently 2 gigabytes).
SQL/92 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
IMAGE data type [BINARY]LONG BINARY data allowing NULL.
IMAGE
IMAGE is implemented in Adaptive Server Anywhere as a user-defined data type, as LONG BINARY allowing NULL. It is provided primarily for compatibility with Adaptive Server Enterprise.
SQL/92 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise.
VARBINARY data type [BINARY]Identical to BINARY.
VARBINARY [ ( n ) ]
Variable length binary strings. The default value for n is one.
SQL/92 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise.