SQL Server Data Types - BINARY

Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5

SQL Server - BINARY
Syntax	BINARY[(n)]
Data	Fixed-length binary data
Parameters	n is the maximum number of bytes, optional
Range	1 ⇐ n ⇐ 8000
Default	n is 1
Storage Size	n bytes
Standards	SQL Server Extension

SQL Server - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	RAW(n), 0 ⇐ n ⇐ 2000, not right padded, variable-length
MySQL	BINARY(n), 0 ⇐ n ⇐ 255
PostgreSQL	BYTEA, 2G, not right padded
Sybase ASE	BINARY, 0 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K), right padded if NOT NULL
Informix	BYTE, 2G, BLOB, 2T

Related Data Types in SQL Server

Data Types
Variable-length binary data	VARBINARY(n \| max)	IMAGE

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird