Ispirer Website
Ispirer Capabilities - Informix Migration
Free Trial
Informix Dynamic Server (IDS) Data Types - BYTE
Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x
| Infromix - BYTE | |
|---|---|
| Syntax | BYTE |
| Data | Variable-length binary data (binary large object) |
| Range | 2G |
| Standards | Informix SQL Extension |
Example:
CREATE TABLE t_byte (c1 BYTE);
Informix BYTE - 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 | BLOB | ||
All Data Types