27 Mar
2007
27 Mar
'07
9:33 p.m.
Vincent Massol wrote:
On Mar 27, 2007, at 4:19 PM, Zeljko Trogrlic wrote:
ILIKE is not in HQL reference. Can somebody running something else than
PostgreSQL test is it working on his system?
If ILIKE doesn't work on other databases, I'll rather keep UPPERs
because fiddling with Hibernate API in Velocity is both impossible and,
to my standards, over-engineered.
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/Restrictio…
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.