Binary data type support differs between Adaptive Server Enterprise, SQL Anywhere and Sybase IQ.
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.
Sybase IQ supports both Adaptive Server Enterprise 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 Enterprise display format is by nibbles, as ‘0x616263’.