Binary data types
284
Binary 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 are
compared exactly while CHAR values are compared using the collation
sequence of the database.
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" on page 284
"VARBINARY data type" on page 285
LONG BINARY data type [BINARY]
Arbitrary length binary data.
LONG BINARY
The maximum size is limited by the maximum size of the database file.
$ For more information on limitations, see "Size and number limitations"
on page 958.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"BINARY data type" on page 284
"VARBINARY data type" on page 285
Function
Function
Syntax
Usage
Parameters
Standards and
compatibility
See also
Function
Syntax
Usage
Standards and
compatibility
See also
To Next Page
Loading...