Available in versions: Dev (3.21) | Latest (3.20) | 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

Built-in data types

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

The SQL standard and most RBDMS agree on a set of well-known primitive data types with a different set of names and variations. These include the following groups of types:

Numeric integers: TINYINT, SMALLINT, INTEGER, BIGINT
Numeric floats: REAL, DOUBLE, FLOAT
Numeric decimals: NUMERIC, DECIMAL
Strings of fixed length: CHAR
Strings of variable length: VARCHAR, CLOB
Binary strings of fixed length: BINARY
Binary strings of variable length: VARBINARY, BLOB
Temporal data types: DATE, TIME, TIMESTAMP

In addition to the above primitives, there are also a few more specialised data types that are frequently seen in RDBMS, including:

Document data types: JSON, JSONB, XML
Spatial data types: GEOMETRY, GEOGRAPHY
Other types: UUID, UUID
And more...

3.14.2.1.: BIGINT (Long)
3.14.2.2.: BIGINT UNSIGNED (ULong)
3.14.2.3.: BINARY (byte[])
3.14.2.4.: BIT (Boolean)
3.14.2.5.: BLOB (byte[])
3.14.2.6.: BOOLEAN (Boolean)
3.14.2.7.: CHAR (String)
3.14.2.8.: CLOB (String)
3.14.2.9.: DATE (Date)
3.14.2.10.: DECFLOAT (Decfloat)
3.14.2.11.: DECIMAL (BigDecimal)
3.14.2.12.: DECIMAL INTEGER (BigInteger)
3.14.2.13.: DOUBLE (Double)
3.14.2.14.: FLOAT (Double)
3.14.2.15.: GEOGRAPHY (Geography)
3.14.2.16.: GEOMETRY (Geometry)
3.14.2.17.: INSTANT (Instant)
3.14.2.18.: INTEGER (Integer)
3.14.2.19.: INTEGER UNSIGNED (UInteger)
3.14.2.20.: INTERVAL (YearToSecond)
3.14.2.21.: INTERVAL DAY TO SECOND (DayToSecond)
3.14.2.22.: INTERVAL YEAR TO MONTH (YearToMonth)
3.14.2.23.: JSON (JSON)
3.14.2.24.: JSONB (JSONB)
3.14.2.25.: LOCALDATE (LocalDate)
3.14.2.26.: LOCALDATETIME (LocalDateTime)
3.14.2.27.: LOCALTIME (LocalTime)
3.14.2.28.: LONGNVARCHAR (String)
3.14.2.29.: LONGVARBINARY (byte[])
3.14.2.30.: LONGVARCHAR (String)
3.14.2.31.: NCHAR (String)
3.14.2.32.: NCLOB (String)
3.14.2.33.: NUMERIC (BigDecimal)
3.14.2.34.: NVARCHAR (String)
3.14.2.35.: OFFSETDATETIME (OffsetDateTime)
3.14.2.36.: OFFSETTIME (OffsetTime)
3.14.2.37.: OTHER (Object)
3.14.2.38.: REAL (Float)
3.14.2.39.: RECORD (Record)
3.14.2.40.: RESULT (Result)
3.14.2.41.: ROWID (RowId)
3.14.2.42.: SMALLINT (Short)
3.14.2.43.: SMALLINT UNSIGNED (UShort)
3.14.2.44.: TIME (Time)
3.14.2.45.: TIMESTAMP (Timestamp)
3.14.2.46.: TIMESTAMP WITH TIME ZONE (OffsetDateTime)
3.14.2.47.: TIME WITH TIME ZONE (OffsetTime)
3.14.2.48.: TINYINT (Byte)
3.14.2.49.: TINYINT UNSIGNED (UByte)
3.14.2.50.: UUID (UUID)
3.14.2.51.: VARBINARY (byte[])
3.14.2.52.: VARCHAR (String)
3.14.2.53.: XML (XML)
3.14.2.54.: YEAR (Year)

previous : next

Feedback

Do you have any feedback about this page? We'd love to hear it!

Tell us a little bit about yourself and join our newsletter (examples)

Built-in data types

Table of contents

Feedback

Community

Support

Legal

Documentation