User Documentation
Ispirer Capabilities - Informix Migration
Pricing
Informix Dynamic Server (IDS) Data Types - BLOB
Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x
| Infromix - BLOB | |
|---|---|
| Syntax | BLOB |
| Data | Variable-length binary data (binary large object) |
| Range | 4 terabyte (4*240 bytes) |
| Standards | Informix SQL Extension |
Example:
CREATE TABLE t_byte (c1 BLOB);
Informix BLOB - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | BLOB, 4G |
| SQL Server | VARBINARY(max), 2G, IMAGE, 2G |
| MySQL | LONGBLOB ,4G |
| PostgreSQL | BYTEA ,2G |
| Sybase ASE | IMAGE ,2G |
Related Data Types in Informix
| Data Types | |||
|---|---|---|---|
| Binary large objects | BYTE | ||
All Data Types