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.
- BLOBs and CLOBs
- BOOLEAN data type
- Unsigned integer types
- INTERVAL data types
- JSON data types
- XML data types
- Geospatial data types
- CURSOR data types
- ARRAY and TABLE data types
- Oracle DATE data type
|The jOOQ User Manual : Reference : Data types||previous : next|