Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

I am using jOOQ with PostgreSQL, and I just realize that my column is case sensitive. Using jOOQ, I didn't found a correct method to query a column, ignoring its case sensitivity. Looking at here : jOOQ TableField Method, I can see that there's equalIgnoreCase. But in the jooq class itself, that method is not there.

Does anybody know what did I do wrong here?

share|improve this question

1 Answer 1

up vote 3 down vote accepted

I'm not quite sure if by "case sensitivity", you mean the column content, or the column name.

  • If you mean the column content, then you found the right method: Field.equalIgnoreCase(). A usage example:

    create.select()
          .from(MY_TABLE)
          .where(MY_TABLE.MY_FIELD.equalIgnoreCase("abc"))
          .fetch();
    
  • If, however, you mean the column name, then you can use the Factory Settings to control how jOOQ renders field and column names. The relevant setting is RenderNameStyle

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["                  <li><a href=\"//area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"//careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2015 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2015.5.22.2603\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Stack Overflow works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class=\"dno\"></div>\r\n    </nos"], "copyright__copyright__copyright": ["      .from(MY_TABLE)\n          .where(MY_TABLE.MY_FIELD.equalIgnoreCase(\"abc\"))\n          .fetch();\n    \n  \u2022 If, however, you mean the column name, then you can use the Factory Settings to control how jOOQ renders field and column names. The relevant setting is RenderNameStyle\n\nshare|improve this answer\n\nYour Answer\n\n\u00a0\ndiscard\n\nBy posting your answer, you agree to the privacy policy and terms of service.\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}