Uppercase support for ILikeExpression. -------------------------------------- Key: HHH-7111 URL: https://hibernate.onjira.com/browse/HHH-7111 Project: Hibernate ORM Issue Type: Improvement Components: query-criteria Reporter: Sebastian If you want to do an ignore case like restriction (with ilike) the resulting SQL always uses the lower function. That's unfortunate especially when an index on a column is uppercase and you want to make use of that index. It's also hard to convince DBAs to change their indexes because Hibernate doesn't support uppercase likes. It would be nice to specify if upper() or lower() in ilike() should be used. I know I can use upper() in HQL but than I would miss out all the advantages of the Criteria API. Cheers, -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira