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]> 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]. > 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.
