About lowercase

manual

Strings in JPQL and Criteria Queries

Explains string expressions in JPQL queries, including LIKE, LOCATE, LOWER, UPPER, TRIM, CONCAT and SUBSTRING.... UPPER(str) functions return a string after conversion to lowercase or uppercase (respectively). For example: ... method Create expression for converting a string to lowercase. See JavaDoc Reference Page... ( path ) ; ...

 
forum_thread

Case Insensitive Indexes

How do you do case insensitive indexes? I have search the Forum and tutorials and have not found any info related to this.   Thanks, -- Nathan Modrzewski... indexes are currently not 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. You can fill a feature request in the issue ...

 
api-jpa

javax.persistence.criteria.CriteriaBuilder

Used to construct criteria queries, compound selections, expressions, predicates, orderings.(Interface of JPA)

 
api-jpa

lower(x)

Create expression for converting a string to lowercase.(Method of javax.persistence.criteria.CriteriaBuilder)

 
manual

JPA Query Expressions (JPQL / Criteria)

Describes JPA query (JPQL / Criteria API) expressions (literals, operators and functions).... method Create expression for converting a string to lowercase. See JavaDoc Reference Page... , upper upper(x) ...

 
manual

JPA Criteria API Queries

Explains how to use the JPA Criteria API (CriteriaBuilder, CriteriaQuery, etc.) to build JPQL like queries.... method Create expression for converting a string to lowercase. See JavaDoc Reference Page... , upper upper(x) ...