Ispirer Website
Ispirer Capabilities - Sybase Migration
Free Trial
Sybase ASE Data Types - VARBINARY
Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x
| Sybase ASE - VARBINARY | |
|---|---|
| Syntax | VARBINARY[(n)] |
| Data | Variable-length binary data |
| Parameters | n is the maximum number of bytes, optional |
| Range | 1 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K) |
| Default | n is 1 |
| Trailing Zeros | Removed when the value is stored |
| Error Handling | Exceeding data truncated without warning |
| Storage Size | Actual entry length |
| Standards | Sybase Transact-SQL Extension |
Sybase ASE VARBINARY - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | RAW(n), 0 ⇐ n ⇐ 2000, BLOB, 4G |
| SQL Server | VARBINARY(n | max), 1 ⇐ n ⇐ 8000, 2G if max is specified |
| MySQL | VARBINARY(n), 1 ⇐ n ⇐ 65535; TINYBLOB, 255 bytes; BLOB, 65535 bytes |
| PostgreSQL | BYTEA, 2G |
| Informix | BYTE, 2G, BLOB, 2T |
Related Data Types in Sybase ASE
All Data Types