Binary data type support differs between Adaptive Server, SQL Anywhere and SAP Sybase IQ.
Data type |
Adaptive Server |
SQL Anywhere |
SAP 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 SAP Sybase IQ, see Unstructured Data Analytics . This feature requires a separate license.
SAP Sybase IQ supports both Adaptive Server and SQL Anywhere display formats.
If ‘123’ is entered in a BINARY field the SQL Anywhere display format is by bytes, as ‘123’; the Adaptive Server display format is by nibbles, as ‘0x616263’.