Guys: The docs have a problem when installing on postgres, since the manual says to use the xwiki Xar AFTER a configured Postgres DB, but no script to create the DB in postgres is given. Is this an error in the doc or have I not understood properly. Regards, Mauricio Hernández Durán Director de Proyectos Ingenian Software LTDA. PBX + 57 (1) 6233606/17 ext 106 Kra 14 #90-31 Ofi 403 Bogotá -----Mensaje original----- De: news [mailto:[email protected]] En nombre de Zeljko Trogrlic Enviado el: Martes, 27 de Marzo de 2007 02:33 p.m. Para: [email protected] Asunto: [xwiki-users] Re: Case insensitive search Vincent Massol wrote:
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/Restriction s.html?
Does anyone know how to use this Expression class in Hibernate?
Thanks -Vincent
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.