BOOLEAN data type
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The SQL standard and some databases support a
BOOLEAN data type with values
NULL. All databases support this data type in the form of an
org.jooq.Condition, a condition or predicate that can be placed in the WHERE clause, among many other places. But true SQL
BOOLEAN data type support means that the data type can be used everywhere a column expression can be used, including the WHERE clause.
BOOLEAN data type is not natively supported, JDBC and most databases translate it to
NULL by convention, although other translations may be possible, including
'FALSE', and many more.
jOOQ, by default, follows the most popular convention and translates to 1/0.