User Documentation
Ispirer Capabilities - Microsoft SQL Server Migration
Pricing
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