Internal Website Search

1-5 of 5 resultsRefresh

Strings in JPQL and Criteria Queries

>The LOWER(str) and UPPER(str) functions return a string after conversion to lowercase or uppercase

Case Insensitive Indexes

supported. If you cannot use lowercase only (or uppercase only) for the data - consider additional field that will contain the content of the orginal string but in lowercase or uppercase

javax.persistence.criteria.CriteriaBuilder

JPA 2 JavaDoc Reference Documentation - Used to construct criteria queries, compound selections, expressions, predicates, orderings.

Make Column values Case insensitive

How do make table column values to case insensitive in object db 2.8.1 version? objdbuser This is currently not supported. A possible workaround is to keep a case-insensitive copy of the relevaant string in a separate field. e.g. in a lowercase format. support Support

lower(x)

"> Create expression for converting a string to lowercase. expression to convert to lowercase