Data Type Case

Controls the casing of data type keywords (INT, VARCHAR, BOOLEAN, etc.) independently from keyword casing.

Scope: Applies to data type keywords in CREATE TABLE column definitions and CAST expressions. Multi-word types (DOUBLE PRECISION) are handled as a unit.

Default: Follows keywordCase. Override with dataTypeCase to set independently (e.g., lowercase keywords with UPPER data types).

Data types follow keyword case by default

Default: data type case follows keywordCase.

create table t (id int, name varchar(100))

create table t (id int, name varchar (100))

Uppercase data types

Explicit upper data type case.

create table t (id int, name varchar(100))

create table t (id int, name varchar (100))

Lowercase data types

Data type keywords lowercase, other keywords uppercase.

CREATE TABLE t (id INT, name VARCHAR(100), active BOOLEAN)

create table t (id int, name varchar (100), active boolean)

Preserve data type case

Keep original casing for data type keywords.

CREATE TABLE t (id Int, name Varchar(100))

create table t (id int, name varchar (100))

Data type case in CAST

Data type case applies in CAST expressions.

select cast(x as int), cast(y as varchar(50)) from t

select cast(x as int), cast(y as varchar (50)) from t

Data type case independent from keyword case

Lower keywords with upper data types.

create table t (id int, name varchar(100))

create table t (id int, name varchar (100))

Data type case with NUMERIC precision

Data types with precision/scale parameters.

create table t (price numeric(10, 2), ratio float)

create table t (price numeric (10, 2), ratio float)

Data type case with multiple keywords

Multi-word data types like DOUBLE PRECISION.

create table t (val double precision)

create table t (val double precision)