Case-insensitive hibernation search without criteria

Question

I want to make case insensitive in a sleeping request. I can do this using criteria, but right now this is not an option for me. The method that invokes the query request introduces the query string as input and is used by other components. Is it possible to resolve a case insensitive to a Hibernate session, or to prepare a criteria object from an hql request.

Answer 1

You can use the functions loweror uppermentioned here .

from User u where lower(u.name) = 'scott'