About lowercase
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 ) ; ...
javax.persistence.criteria.CriteriaBuilder
Used to construct criteria queries, compound selections, expressions, predicates, orderings.(Interface of JPA)
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 ...
lower(x)
Create expression for converting a string to lowercase.(Method of javax.persistence.criteria.CriteriaBuilder)
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) ...
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) ...