The jOOQ User Manual SQL building Data types Built-in data types BIT (Boolean)

previous : next

BIT (Boolean)

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

The BIT data type represents a boolean type, or java.lang.Boolean in Java, or Types.BIT in JDBC.

DDL support

Dialect support

This example using jOOQ:

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

Translates to the following dialect specific expressions:

Access, Aurora MySQL, BigQuery, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, MariaDB, MemSQL, MySQL, SQLDataWarehouse, SQLServer, Trino

CREATE TABLE t (
  c bit
)

ASE, Sybase

CREATE TABLE t (
  c bit NULL
)

Aurora Postgres, CockroachDB, Derby, Informix, Postgres, Redshift, SQLite, Vertica, YugabyteDB

CREATE TABLE t (
  c boolean
)

ClickHouse

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

Databricks

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

DB2

CREATE TABLE t (
  c smallint
)

Oracle, Snowflake, Teradata

CREATE TABLE t (
  c number
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), BIT)

Translates to the following dialect specific expressions:

Access

cbool(c)

ASE, BigQuery, Databricks, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, SQLDataWarehouse, SQLServer, Sybase, Trino

CAST(c AS bit)

Aurora MySQL, MariaDB, MemSQL, MySQL

CAST(c AS unsigned)

Aurora Postgres, CockroachDB, Derby, Informix, Postgres, Redshift, SQLite, Vertica, YugabyteDB

CAST(c AS boolean)

ClickHouse

CAST(c AS Nullable(bit))

DB2

CAST(c AS smallint)

Oracle, Snowflake, Teradata

CAST(c AS number(1))

The jOOQ User Manual SQL building Data types Built-in data types BIT (Boolean)

previous : next