Hi Lukas,
I'm not sure how COLLATE will solve this issue on Postgres, at least not without creating a custom collation. Postgres has the CITEXT <https://www.postgresql.org/docs/current/static/citext.html> field type specifically for case insensitive comparisons. Do you mind elaborating how collation solves the issue with respect to string comparison (not sorting) On Friday, September 21, 2018 at 6:03:03 AM UTC-4, Lukas Eder wrote: > > Hi Max, > > Thanks for your message. The correct way to handle case insensitivity is > to use collations (in most databases). The existing equalIgnoreCase() > method uses LOWER(), internally, which doesn't behave correctly in all > languages. > > Starting with jOOQ 3.11, collations are now supported: > https://github.com/jOOQ/jOOQ/issues/2908 > > I remember having rejected a similar feature request like yours much > earlier, but I can't seem to find the relevant Github issue or user group > message. I do believe that this rejection was because of the lack of > collation support in jOOQ at the time. Things have changed now, and it > should be possible, in the future, to override the case-insensitivity > feature of these methods to use collations instead of LOWER(): > https://github.com/jOOQ/jOOQ/issues/7881 > > So, here's your feature request, due for jOOQ 3.12: > https://github.com/jOOQ/jOOQ/issues/7882 > > Thanks, > Lukas > > On Thu, Sep 20, 2018 at 10:05 PM Max Kremer <[email protected] > <javascript:>> wrote: > >> Hello again Lukas! >> >> >> I noticed the contains and equals and ignoreCase analogues. It would >> be great if Field.startWith and Field.endsWith also had versions that >> ignored case. Pretty simple request this time :) >> >> Thanks, >> Max >> >> -- >> You received this message because you are subscribed to the Google Groups >> "jOOQ User Group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
