Unsigned integer types

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

Some databases explicitly support unsigned integer data types. In most normal JDBC-based applications, they would just be mapped to their signed counterparts letting bit-wise shifting and tweaking to the user. jOOQ ships with a set of unsigned java.lang.Number implementations modelling the following types:

• org.jooq.types.UByte: Unsigned byte, an 8-bit unsigned integer
• org.jooq.types.UShort: Unsigned short, a 16-bit unsigned integer
• org.jooq.types.UInteger: Unsigned int, a 32-bit unsigned integer
• org.jooq.types.ULong: Unsigned long, a 64-bit unsigned integer

Each of these wrapper types extends java.lang.Number, wrapping a higher-level integer type, internally:

• UByte wraps java.lang.Short
• UShort wraps java.lang.Integer
• UInteger wraps java.lang.Long
• ULong wraps java.math.BigInteger