The jOOQ User Manual SQL building Data types Built-in data types TINYINT (Byte)

previous : next

TINYINT (Byte)

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

The TINYINT data type represents a signed, 8 bit integer, or java.lang.Byte in Java, or Types.TINYINT in JDBC.

DDL support

Dialect support

This example using jOOQ:

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

Translates to the following dialect specific expressions:

Access, Hana, SQLDataWarehouse

CREATE TABLE t (
  c signed tinyint
)

ASE

CREATE TABLE t (
  c signed tinyint NULL
)

Aurora MySQL, DuckDB, Exasol, H2, HSQLDB, MariaDB, MemSQL, MySQL, SQLServer, SQLite, Trino, Vertica

CREATE TABLE t (
  c tinyint
)

Aurora Postgres, CockroachDB, DB2, Derby, Firebird, Informix, Postgres, Redshift, YugabyteDB

CREATE TABLE t (
  c smallint
)

BigQuery

CREATE TABLE t (
  c int64
)

ClickHouse

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

Databricks

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

Oracle, Snowflake

CREATE TABLE t (
  c number(3)
)

Sybase

CREATE TABLE t (
  c tinyint NULL
)

Teradata

CREATE TABLE t (
  c byteint
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), TINYINT)

Translates to the following dialect specific expressions:

Access

cbyte(c)

ASE, Databricks, DuckDB, Exasol, H2, HSQLDB, Hana, SQLDataWarehouse, SQLServer, SQLite, Sybase, Trino, Vertica

CAST(c AS tinyint)

Aurora MySQL, MariaDB, MemSQL, MySQL

CAST(c AS signed)

Aurora Postgres, CockroachDB, DB2, Derby, Firebird, Informix, Postgres, Redshift, YugabyteDB

CAST(c AS smallint)

BigQuery

CAST(c AS int64)

ClickHouse

CAST(c AS Nullable(tinyint))

Oracle, Snowflake

CAST(c AS number(3))

Teradata

CAST(c AS byteint)

The jOOQ User Manual SQL building Data types Built-in data types TINYINT (Byte)

previous : next