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

previous : next

LONGVARCHAR (String)

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

The LONGVARCHAR data type represents a variable length string type, or java.lang.String in Java, or Types.LONGVARCHAR in JDBC.

This data type is mostly offered as a compatibility type as the difference between this type and other variable length binary types like VARCHAR (String) and CLOB (String) is not very well defined.

DDL support

Dialect support

This example using jOOQ:

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

Translates to the following dialect specific expressions:

Access

CREATE TABLE t (
  c longtext
)

ASE

CREATE TABLE t (
  c text NULL
)

Aurora MySQL, MariaDB, MemSQL, MySQL

CREATE TABLE t (
  c text
)

Aurora Postgres, CockroachDB, DuckDB, Postgres, Redshift, Snowflake, Trino, YugabyteDB

CREATE TABLE t (
  c varchar
)

BigQuery

CREATE TABLE t (
  c string
)

ClickHouse

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

Databricks

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

DB2, Hana, Informix

CREATE TABLE t (
  c clob
)

Exasol, H2, HSQLDB, SQLite

CREATE TABLE t (
  c longvarchar
)

Firebird

CREATE TABLE t (
  c varchar(4000)
)

Oracle

CREATE TABLE t (
  c varchar2(4000)
)

Spanner

CREATE TABLE t (
  c string(2621440)
)

SQLDataWarehouse

CREATE TABLE t (
  c varchar(8000)
)

SQLServer

CREATE TABLE t (
  c varchar(max)
)

Sybase

CREATE TABLE t (
  c long varchar NULL
)

Teradata

CREATE TABLE t (
  c varchar(32000)
)

Vertica

CREATE TABLE t (
  c long varchar
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), LONGVARCHAR)

Translates to the following dialect specific expressions:

Access

cstr(c)

ASE

CAST(c AS text)

Aurora MySQL, MariaDB, MemSQL, MySQL

CAST(c AS char)

Aurora Postgres, CockroachDB, DuckDB, Postgres, Redshift, Snowflake, Trino, YugabyteDB

CAST(c AS varchar)

BigQuery, Databricks, Spanner

CAST(c AS string)

ClickHouse

CAST(c AS Nullable(String))

DB2, Hana, Informix

CAST(c AS clob)

Exasol, H2, HSQLDB, SQLite

CAST(c AS longvarchar)

Firebird

CAST(c AS varchar(4000))

Oracle

CAST(c AS varchar2(4000))

SQLDataWarehouse

CAST(c AS varchar(8000))

SQLServer

CAST(c AS varchar(max))

Sybase, Vertica

CAST(c AS long varchar)

Teradata

CAST(c AS varchar(32000))

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

previous : next