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


© 1999-2023, Ispirer Systems, LLC. All Rights Reserved.