NCLOB

From Oracle FAQ

NCLOB (National Character Large Object) is an Oracle data type that can hold up to 4 GB of character data. It's similar to a CLOB, but characters are stored in a NLS or multibyte national character set.

[edit] Examples

CREATE TABLE t1(c1 NCLOB);

INSERT INTO t1 VALUES( N'any nchar literal' );

[edit] Also see

• CLOB - similar to NCLOB, but for normal characters
• NVARCHAR2