The jOOQ User Manual SQL building Data types Built-in data types INTEGER (Integer)

previous : next

INTEGER (Integer)

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

The INTEGER data type represents a signed, 32 bit integer, or java.lang.Integer in Java, or Types.INTEGER in JDBC

DDL support

Dialect support

This example using jOOQ:

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

Translates to the following dialect specific expressions:

Access, DB2, Firebird, Hana, Informix, Teradata

CREATE TABLE t (
  c integer
)

ASE, Sybase

CREATE TABLE t (
  c int NULL
)

Aurora MySQL, Aurora Postgres, Derby, DuckDB, Exasol, H2, HSQLDB, MariaDB, MemSQL, MySQL, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Trino, Vertica, YugabyteDB

CREATE TABLE t (
  c int
)

BigQuery

CREATE TABLE t (
  c int64
)

ClickHouse

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

CockroachDB

CREATE TABLE t (
  c int4
)

Databricks

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

Oracle, Snowflake

CREATE TABLE t (
  c number(10)
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), INTEGER)

Translates to the following dialect specific expressions:

Access

clng(c)

ASE, Aurora Postgres, Databricks, Derby, DuckDB, Exasol, H2, HSQLDB, Postgres, Redshift, SQLDataWarehouse, SQLServer, SQLite, Sybase, Trino, Vertica, YugabyteDB

CAST(c AS int)

Aurora MySQL, MariaDB, MemSQL, MySQL

CAST(c AS signed)

BigQuery

CAST(c AS int64)

ClickHouse

CAST(c AS Nullable(integer))

CockroachDB

CAST(c AS int4)

DB2, Firebird, Hana, Informix, Teradata

CAST(c AS integer)

Oracle, Snowflake

CAST(c AS number(10))

The jOOQ User Manual SQL building Data types Built-in data types INTEGER (Integer)

previous : next