Binary data types

The following table summarizes binary data type support.

**Table A-1: Binary data type supported sizes**
Data type	Adaptive Server Enterprise	Adaptive Server Anywhere	IQ
BINARY	< page size	32KB - 1	255
VARBINARY	< page size	32KB - 1	32KB - 1
LONG BINARY*	not supported	2GB - 1	512TB (IQ page size 128KB) 2PB (IQ page size 512KB)
IMAGE	2GB	2GB - 1	use LONG BINARY*

*For information on the LONG BINARY data type in Sybase IQ, see Large Objects Management in Sybase IQ. This feature requires a separate license.

Adaptive Server Enterprise and Adaptive Server Anywhere display binary data differently when projected:

IQ supports both Adaptive Server Enterprise and Adaptive Server Anywhere display formats
If ‘123’ is entered in a BINARY field the Adaptive Server Anywhere display format is by bytes, as ‘123’; the Adaptive Server Enterprise display format is by nibbles, as ‘0x616263’