Binary Data Types

Binary data type support differs between Adaptive Server Enterprise, SQL Anywhere and Sybase IQ.

Binary data type supported sizes

Data type

Adaptive Server Enterprise

SQL 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 Unstructured Data Analytics in Sybase IQ. This feature requires a separate license.

Adaptive Server Enterprise and SQL Anywhere display binary data differently when projected:
Related reference
Binary Data Types
NEWID Function [Miscellaneous]
STRTOUUID Function [String]
UUIDTOSTR Function [String]
Character Data Types