Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Data Types - BLOB
Versions: Oracle 11g, 10g, 9i and 8i
| Oracle - BLOB | |
|---|---|
| Syntax | BLOB |
| Data | Variable-length binary data (binary large object) |
| Range | 4G |
| Transactions | BLOB objects have full transactional support, any changes can be committed or rolled back |
| Internals | Data up to 4000 bytes can be stored inline if you enable ENABLE STORAGE IN ROW option (this is the default). Data greater than 4000 bytes are always stored externally and you can specify different tablespace and storage characteristics |
| Standards | Oracle Extension |
Oracle BLOB - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| SQL Server | VARBINARY(max), 2G, IMAGE, 2G |
| MySQL | LONGBLOB, 4G |
| PostgreSQL | BYTEA, 2G |
| Sybase ASE | IMAGE, 2G |
| Informix | BYTE, 2G, BLOB, 2T |
Related Data Types in Oracle
All Data Types