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

previous : next

NCHAR (String)

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

The NCHAR data type represents a fixed length "national" (unicode) string type, or java.lang.String in Java, or Types.NCHAR in JDBC.

Given the fixed size characteristic, the NCHAR type should be accompanied by an explicit length flag.

DDL support

Dialect support

This example using jOOQ:

createTable("t").column("c", NCHAR(3))

Translates to the following dialect specific expressions:

Access

CREATE TABLE t (
  c text(3)
)

ASE, Sybase

CREATE TABLE t (
  c nchar(3) NULL
)

Aurora MySQL, Aurora Postgres, CockroachDB, DB2, Derby, DuckDB, Firebird, HSQLDB, MariaDB, MemSQL, MySQL, Postgres, Redshift, Snowflake, Teradata, Trino, Vertica, YugabyteDB

CREATE TABLE t (
  c char(3)
)

BigQuery

CREATE TABLE t (
  c string
)

ClickHouse

CREATE TABLE t (
  c Nullable(char(3))
)
ENGINE Log()

Databricks

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

Exasol, H2, Hana, Informix, Oracle, SQLDataWarehouse, SQLServer, SQLite

CREATE TABLE t (
  c nchar(3)
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), NCHAR(3))

Translates to the following dialect specific expressions:

Access

cstr(c)

ASE, Exasol, H2, Hana, Informix, SQLDataWarehouse, SQLServer, SQLite, Sybase

CAST(c AS nchar(3))

Aurora MySQL, Aurora Postgres, CockroachDB, Databricks, Derby, DuckDB, Firebird, HSQLDB, MariaDB, MemSQL, MySQL, Postgres, Redshift, Snowflake, Teradata, Trino, Vertica, YugabyteDB

CAST(c AS char(3))

BigQuery

CAST(c AS string)

ClickHouse

CAST(c AS Nullable(char(3)))

DB2

CAST(c AS varchar(3))

Oracle

CAST(c AS nvarchar2(3))

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

previous : next