Hibernate version: 2

Name and version of the database you are using: PostgreSQL, but would like to be DB independant

Problem:
I need to be able to escape both % and _ (probably the escaped char too) in with a like clause in a find.

Example:

from DomesticCat cat where cat.name like 'FRI%'

What do I do if I only want the cat named FRI%?

I tried to backslash the \ or the _ but it doesn't seem to work. Tryed also to do it the same way it is done in the like in Postgresql ('\\\%') but it doesn't work too.

In HB3 you can type:




Note sure if this works in HB2.

Thanks for the info, I may try it too.

But I just found a way:

- updated to last Hibernate (2.1.8)

- (Tested with PostgreSQL, hope it's not base dependant)

\ remplaced by \\\\


% are escaped with \\\%


_ are remplaced by \\\_

This is base dependant.

I also needed to change like for ilike as I needed a caseless comparison. (and ilike is how you do it in postgresql).

Can the escape char also be defined in a Criteria query?

What about the Restrictions.like(String searchString, MatchMode) versions? In theory they would not need any wildcard char in the searchString, because the MatchMode says it all (either at the end, at the beginning, both, or none at all). What happens if I call Restrictions.like("FRI%", MatchMode.END)?

Regards,

Andreas

The following worked in Hibernate 3:
criteria.add(Restrictions.ilike("nameTx", "B\\_1", MatchMode.ANYWHERE));

The following did not appear to work:
criteria.add(Restrictions.ilike("nameTx", "B_1 escape _", MatchMode.ANYWHERE));

srceString.replaceAll("_", "\\_")

This doesn't work with HSQLDB.