Hi,

I am writing CriteriaQuery. To escape special characters such as '[' I use Restrictions.Like(string propertyName, string value, MatchMode matchMode, char? escapeChar);
It is working fine for all Databases.

But now I want to add CaseInsensitivity. For this I have found the function Restrictions.InsensitiveLike(string propertyName, string value, MatchMode matchMode);

but this function does not contain escapeChar parameter. So I can not escape special characters.

Is there any way to make the HQL case insensitive and also escape special characters?

Thanks in Advance.

Regards,
Niranjan

I am not sure if I am being very helpful but in case u have no need for case sensitive "like"s throughout your application, u might turn case-sensitivity off at your database instead of hibernate. Most databases have such a feature.

Hi,

Thanks for the reply.

I dont want to do any database specific things. Otherwise I have to do those changes in all databases.

If I can get the function such as Restrictions.Like(string propertyName, string value, MatchMode matchMode, char? escapeChar); for Restrictions.InsensitiveLike then I think it would be better.

Hope NHibernate guys will provide this functionality soon.

Regards,
Niranjan

Hi,

Is there any updates on the issue?

Regards,
Niranjan