Ah, I think I see. TRIM in HSQL is not really ANSI SQL compliant; it does not seem to support specifying the character to trim, is that the issue? I assume it can only trim spaces then?

So here is the rub with that... TRIM is defined by JPA to mean the full ANSI SQL variant.