Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Data Types - RAW
Versions: Oracle 11g, 10g, 9i, 8i and 7.3
| Oracle - RAW | |
|---|---|
| Syntax | RAW(p) |
| Data | Variable-length binary data |
| Range | 1 ⇐ p ⇐ 2000 |
| Defaults | You must specify the size for RAW columns |
| Standards | Oracle Extension |
Oracle RAW - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| SQL Server | VARBINARY(n | max), 1 ⇐ n ⇐ 8000, 2G if max is specified |
| MySQL | VARBINARY(p) - 1 ⇐ p ⇐ 65535; BLOB - 65535 bytes |
| PostgreSQL | BYTEA , 2G |
| Sybase ASE | VARBINARY(p) - 1 ⇐ n ⇐ pagesize (2K, 4K, 8K or 16K) |
| Informix | BYTE, 2G, BLOB, 2T |
Related Data Types in Oracle
All Data Types