Data types

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

There is always a small mismatch between SQL data types and Java data types. This is for two reasons:

• SQL data types are insufficiently covered by the JDBC API.
• Java data types are often less expressive than SQL data types

This chapter should document the most important notes about SQL, JDBC and jOOQ data types.

Table of contents

8.4.1.

BLOBs and CLOBs

8.4.2.

BOOLEAN data type

8.4.3.

Unsigned integer types

8.4.4.

INTERVAL data types

8.4.5.

JSON data types (new)

8.4.6.

XML data types

8.4.7.

Geospatial data types

8.4.8.

CURSOR data types

8.4.9.

ARRAY and TABLE data types

8.4.10.

Oracle DATE data type