Binary data types

Table A-1 summarizes binary data type support.

Table A-1: Binary data type supported sizes

Data type

Adaptive Server Enterprise

Adaptive Server Anywhere

Sybase 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: