Ask Questions and Find Answers

Hi,

Is there any way of make dynamic query insensitive to accent marks? I am able to make it insensitive to upper or lower case but not when is related to accents mark

I've tried with ilike, but this two queries give different results:

entryQuery = UserLocalServiceUtil.dynamicQuery();
entryQuery.add(RestrictionsFactoryUtil.ilike("firstName", "%José%"));
results = UserLocalServiceUtil.dynamicQuery(entryQuery);

entryQuery = UserLocalServiceUtil.dynamicQuery();
entryQuery.add(RestrictionsFactoryUtil.ilike("firstName", "%Jose%"));
results = UserLocalServiceUtil.dynamicQuery(entryQuery);

Thanks in advance,

Regards