27 Mar
2007
27 Mar
'07
7:02 p.m.
On Mar 27, 2007, at 4:19 PM, Zeljko Trogrlic wrote:
Esbach, Brandon <Esbachb@...> writes:
Are you sure there isn't any hibernate-specific solution to the
problem? (which IMO might be better)
What about using something like the ilike in http://www.hibernate.org/
hib_docs/v3/api/org/hibernate/criterion/Restrictions.html? Does
anyone know how to use this Expression class in Hibernate?
Thanks
-Vincent
PostgreSQL treats LIKE queries as case-sensitive;
so to
make it case-insensitive you would have to use ilike (extra i in
front of
like) to make it case-insensitive.
ILIKE is PostgreSQL specific. Two UPPERCASE will work on any database.