The jOOQ User Manual SQL building Data types Built-in data types BIGINT (Long)

previous : next

BIGINT (Long)

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

The BIGINT data type represents a signed, 64 bit integer, or java.lang.Long in Java, or Types.BIGINT in JDBC.

DDL support

Dialect support

This example using jOOQ:

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

Translates to the following dialect specific expressions:

Access

CREATE TABLE t (
  c numeric
)

ASE, Sybase

CREATE TABLE t (
  c bigint NULL
)

Aurora MySQL, Aurora Postgres, CockroachDB, DB2, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MariaDB, MemSQL, MySQL, Postgres, Redshift, SQLDataWarehouse, SQLServer, Teradata, Trino, Vertica, YugabyteDB

CREATE TABLE t (
  c bigint
)

BigQuery

CREATE TABLE t (
  c int64
)

ClickHouse

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

Databricks

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

Oracle, Snowflake

CREATE TABLE t (
  c number(19)
)

SQLite

CREATE TABLE t (
  c int8
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), BIGINT)

Translates to the following dialect specific expressions:

Access

cdec(c)

ASE, Aurora Postgres, CockroachDB, DB2, Databricks, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, Postgres, Redshift, SQLDataWarehouse, SQLServer, Sybase, Teradata, Trino, Vertica, YugabyteDB

CAST(c AS bigint)

Aurora MySQL, MariaDB, MemSQL, MySQL

CAST(c AS signed)

BigQuery

CAST(c AS int64)

ClickHouse

CAST(c AS Nullable(bigint))

Oracle, Snowflake

CAST(c AS number(19))

SQLite

CAST(c AS int8)

The jOOQ User Manual SQL building Data types Built-in data types BIGINT (Long)

previous : next