The jOOQ User Manual SQL building Data types Converted data types

previous : next

Converted data types

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

A converted data type is a type that is being converted to some user data structure, which can be independent of any data structures from the database. There are tons of use-cases for converted data types:

• To attach more semantic types to certain primitives, e.g. Email instead of just String (see also DOMAIN types to do this directly within the database)
• To increase type safety, and to avoid comparing two seemingly related types (VARCHAR and VARCHAR), which aren't really comparable (e.g. Email and Username)
• To work with libraries instead of raw data, e.g. JAXB or Jackson bindings instead of raw XML types or raw JSON types

Table of contents

3.11.7.1.

Custom data type Converter

3.11.7.2.

Custom data type Binding

The jOOQ User Manual SQL building Data types Converted data types

previous : next