Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Data Types - CLOB
Versions: Oracle 11g, 10g, 9i and 8i
| Oracle - CLOB | |
|---|---|
| Syntax | CLOB |
| Data | Variable-length character data (character large object), single-byte and multibyte character sets |
| Range | 4G |
| Character Set | Database default |
| 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 CLOB - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| SQL Server | VARCHAR(max) or TEXT, 2G |
| MySQL | LONGTEXT, 4G |
| PostgreSQL | TEXT, 1G |
| Sybase ASE | TEXT, 2G |
| Informix | TEXT, 2G, CLOB, 4T |
| HP Neoview | VARCHAR(n), 1 ⇐ n ⇐ (32708 - size of other columns) |
| Ingres | TEXT(n), 1 ⇐ n ⇐ 32000; LONG VARCHAR, 2G |
Related Data Types in Oracle
| Data Types | ||
|---|---|---|
| Fixed-length Character Data | CHAR(n) | NCHAR(n) |
| Variable-length Character Data | VARCHAR2(n) | NVARCHAR2(n) |
| Character Large Objects | NCLOB | LONG |
All Data Types