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

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

Data Types
Fixed-length binary data BINARY(p)
Variable-length binary data IMAGE

All Data Types

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.