New versions: Dev (3.14) | Latest (3.13) | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | Old versions: 3.7 | 3.6 | 3.5 | 3.4 | 3.3 | 2.6

String functions

Available in ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

String formatting can be done efficiently in the database before returning results to your Java application. As discussed in the chapter about SQL dialects string functions (as any function type) are mostly emulated in your database, in case they are not natively supported.

Table of contents

4.6.11.1.
ASCII
4.6.11.2.
CONCAT
4.6.11.3.
LEFT
4.6.11.4.
LENGTH
4.6.11.5.
LOWER
4.6.11.6.
LPAD
4.6.11.7.
LTRIM
4.6.11.8.
MD5
4.6.11.9.
POSITION
4.6.11.10.
REPEAT
4.6.11.11.
REPLACE
4.6.11.12.
REVERSE
4.6.11.13.
RIGHT
4.6.11.14.
RPAD
4.6.11.15.
RTRIM
4.6.11.16.
SPACE
4.6.11.17.
SUBSTRING
4.6.11.18.
TRANSLATE
4.6.11.19.
TRIM
4.6.11.20.
UPPER

The jOOQ User Manual. Multiple Pages : SQL building : Column expressions : String functionsprevious : next
The jOOQ Logo