Sybase ASE Data Types - VARBINARY

Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x

Sybase ASE - VARBINARY
Syntax	VARBINARY[(n)]
Data	Variable-length binary data
Parameters	n is the maximum number of bytes, optional
Range	1 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K)
Default	n is 1
Trailing Zeros	Removed when the value is stored
Error Handling	Exceeding data truncated without warning
Storage Size	Actual entry length
Standards	Sybase Transact-SQL Extension

Sybase ASE VARBINARY - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	RAW(n), 0 ⇐ n ⇐ 2000, BLOB, 4G
SQL Server	VARBINARY(n \| max), 1 ⇐ n ⇐ 8000, 2G if max is specified
MySQL	VARBINARY(n), 1 ⇐ n ⇐ 65535; TINYBLOB, 255 bytes; BLOB, 65535 bytes
PostgreSQL	BYTEA, 2G
Informix	BYTE, 2G, BLOB, 2T

Related Data Types in Sybase ASE

Data Types
Fixed-length binary data	BINARY(p)
Variable-length binary data	IMAGE

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird