Sybase ASE Data Types - BINARY

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

Sybase ASE - BINARY
Syntax	BINARY[(n)]
Data	Fixed-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
Padding	Right-padded with 0 bytes to n only if NOT NULL
Error Handling	Exceeding data truncated without warning
Storage Size	n bytes
Internals	If defined as NULL, it is automatically converted to VARBINARY without warning
Standards	Sybase Transact-SQL Extension

Sybase ASE BINARY - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	RAW(n), 0 ⇐ n ⇐ 2000, not right padded, variable length
SQL Server	BINARY(n), 1 ⇐ n ⇐ 8000
MySQL	BINARY(n), 0 ⇐ n ⇐ 255
PostgreSQL	BYTEA, 2G, not right padded
Informix	BYTE, 2G, BLOB, 2T

Related Data Types in Sybase ASE

Data Types
Variable-length binary data	VARBINARY(p)	IMAGE

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird