hello,

Why is it that my like query fails to return any values when I call it in the following way?


criteria.add( Restrictions.like(attribute, values.toString(),MatchMode.ANYWHERE));

CASE 1
attribute - Headline
values = "\"

No values are returned eventhough the DB clearly shows values such as "hello\"

CASE 2
attribute - Headline
values = "\\"

All values with \\ and \ are returned including "hello\".


IMHO, \ is the default escape character for hibernate.
How can I make the former query work as it is supposed to?


Thank you for you help.

Hibernate version:
hibernate3