Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

SQL Server Data Types - IMAGE

Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5

SQL Server - IMAGE
Syntax IMAGE
Data Variable-length binary data
Range 2G
Notes IMAGE data type will be removed in future versions of SQL Server, it is recommended to use VARBINARY(max)
Standards SQL Server Extension

SQL Server IMAGE - Equivalents in Other Databases

Database Data Type and Conversion
Oracle BLOB, 4G
MySQL LONGBLOB, 4G
PostgreSQL BYTEA, 2G
Sybase ASE IMAGE, 2G
Informix BYTE, 2G, BLOB, 2T

Related Data Types in SQL Server

Data Types
Fixed-length binary data BINARY(n)
Variable-length binary data VARBINARY(n | max)

All Data Types


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