Ispirer Website Ispirer Capabilities - Sybase Migration Free Trial

Sybase ASE Data Types - IMAGE

Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x

Sybase ASE - IMAGE
Syntax IMAGE
Data Variable-length binary data
Range 231-1 bytes (2G)
Storage Size 0 bytes when empty, otherwise multiple of 2K
Internals Data is stored in data pages that are separate from the rest of the table
Standards Sybase Transact-SQL Extension

Sybase ASE IMAGE - Equivalents in Other Databases

Database Data Type and Conversion
Oracle BLOB, 4G
SQL Server VARBINARY(max), 2G, IMAGE, 2G
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 VARBINARY(p)

All Data Types

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