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.2.1.

BLOBs and CLOBs

8.2.2.

Unsigned integer types

8.2.3.

INTERVAL data types

8.2.4.

XML data types

8.2.5.

Geospacial data types

8.2.6.

CURSOR data types

8.2.7.

ARRAY and TABLE data types

8.2.8.

Oracle DATE data type