|
varbinary(n)
The term varbinary(n) describes a
datatype,
or
binary datatype.
Like all binary datatypes, the datatype varbinary(n) is also an extension to
Transact-SQL.
The datatype varbinary(n) requires n
bytes
of
storage,
with values for n less than 16296 (n <= 16296).
Usage of the datatype varbinary(n)
The maximum length of varbinary(n) depends on the
page size
configured in
ASE Server
and on the
lock scheme
of the
table.
If the limits are not known or need to be changed, the commands
dbcc serverlimits
or
lockscheme()
might be of help. Independent from the "page size" of the ASE server, varbinary(n)
is used for raw data not larger than 16384 bytes.
See also:
Binary Datatypes,
binary(),
bit,
image.
|
