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