The jOOQ User Manual SQL building Data types Built-in data types NCLOB (String)

previous : next

NCLOB (String)

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The NCLOB (National Character Large OBject) data type represents a variable length "national" (unicode) string type, or java.lang.String in Java, or Types.NCLOB in JDBC.

Some RDBMS support different variable size string types, where the NCLOB type allows for very big objects to be stored in separate storage. In those RDBMS, NCLOB may behave subtly differently from NVARCHAR (String).

DDL support

Dialect support

This example using jOOQ:

createTable("t").column("c", NCLOB)

Translates to the following dialect specific expressions:

Access

CREATE TABLE t (
  c longtext
)

ASE

CREATE TABLE t (
  c unitext NULL
)

Aurora MySQL, Aurora Postgres, CockroachDB, MariaDB, MemSQL, MySQL, Postgres, Redshift, YugabyteDB

CREATE TABLE t (
  c text
)

BigQuery, DuckDB

CREATE TABLE t (
  c string
)

ClickHouse

CREATE TABLE t (
  c Nullable(varchar)
)
ENGINE Log()

Databricks

CREATE TABLE t (
  c string
)
TBLPROPERTIES(
  'delta.columnMapping.mode' = 'name',
  'delta.feature.allowColumnDefaults' = 'supported'
)

DB2, Derby, Exasol, HSQLDB, Informix, Teradata, Vertica

CREATE TABLE t (
  c clob
)

Firebird

CREATE TABLE t (
  c blob sub_type text
)

H2, Hana, Oracle, SQLite

CREATE TABLE t (
  c nclob
)

Snowflake, Trino

CREATE TABLE t (
  c varchar
)

SQLDataWarehouse

CREATE TABLE t (
  c nvarchar
)

SQLServer

CREATE TABLE t (
  c nvarchar(max)
)

Sybase

CREATE TABLE t (
  c ntext NULL
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), NCLOB)

Translates to the following dialect specific expressions:

Access

cstr(c)

ASE

CAST(c AS unitext)

Aurora MySQL, MariaDB, MemSQL, MySQL

CAST(c AS char)

Aurora Postgres, CockroachDB, Postgres, Redshift, YugabyteDB

CAST(c AS text)

BigQuery, Databricks, DuckDB

CAST(c AS string)

ClickHouse

CAST(c AS Nullable(varchar))

DB2, Derby, Exasol, HSQLDB, Informix, Teradata, Vertica

CAST(c AS clob)

Firebird

CAST(c AS blob sub_type text)

H2, Hana, SQLite

CAST(c AS nclob)

Oracle

to_clob(c)

Snowflake, Trino

CAST(c AS varchar)

SQLDataWarehouse

CAST(c AS nvarchar)

SQLServer

CAST(c AS nvarchar(max))

Sybase

CAST(c AS ntext)

The jOOQ User Manual SQL building Data types Built-in data types NCLOB (String)

previous : next