Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Data Types - NCLOB
Versions: Oracle 11g, 10g, 9i and 8i
| Oracle - NCLOB | |
|---|---|
| Syntax | NCLOB |
| Data | Variable-length character data (character large object) in Unicode - UTF-8 or UTF-16 |
| 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 NCLOB - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| SQL Server | NVARCHAR(n | max), 1 ⇐ n ⇐ 4000, 2G if max is specified, NTEXT, 2G, Unicode - UCS-2 |
| MySQL | LONGTEXT, 4G |
| PostgreSQL | TEXT, 1G |
| Sybase ASE | UNITEXT, 2G, Unicode |
| 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; LONG NVARCHAR, 2G, Unicode - UTF-8 |
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 | CLOB | LONG |
All Data Types