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:
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.
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