> Would the factory also generate a md5() function for HSQL (assuming that > you've tweaked your HSQL with a function called md5 that takes a varchar)?
Yes, the default function name rendered by org.jooq.impl.MD5 will be "md5". It will work, although this might (improbably) change in the future. > Also, and only FWIW, I've noticed with Oracle that dbms_obfuscation_toolkit > has a 32K varchar input limit, where dbms_crypto can operate on lobs. Nice hint. DBMS_CRYPTO also supports a lot more algorithms. I'll fix that Cheers Lukas
