The underscore character "_" is ignored in our search criteria. For example a search for "BANK_1" returns "BANK 1" ignoring the underscore.

Search criteria: criteria.add(Restrictions.ilike("nameTx", searchName, MatchMode.ANYWHERE));

searchName = "BANK_1"

We are using hibernate 3. Can anyone provide any insight as to why the underscore is ignored ? Any suggestions will be appreciated.

Thank you.

underscores are often wildcards for a single character in SQL

Thanks for your reply. I just needed to treat the underscore as an escape character.

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("_", "\\_")

don't forget to rate ;)