Available in versions: Dev (3.20)

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

Fetching trimmed CHAR types

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

Historically, fixed-length CHAR types used to be more present in schemas than the more useful variable length VARCHAR or even TEXT / CLOB types. To support variable length strings inside of CHAR types, strings were typically right-padded with whitespace. This can be annoying in Java based client applications, where the strings have to be trimmed manually, or using SQL RTRIM function calls. Specifically, dictionary views of these RDBMS still use CHAR typed strings very often:

  • Db2
  • Firebird
  • Informix
  • Teradata

To avoid having to manually right-trim these strings, the following Settings can be specified to do this automatically in jOOQ at the JDBC level:

Settings settings = new Settings()
    .withFetchTrimmedCharValues(true); // Default to false


Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo