Message Boards
Dynamic query with accents
Daniel G, modified 2 Years ago.
Dynamic query with accents
Regular Member Posts: 141 Join Date: 3/14/17 Recent PostsHi,
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
Olaf Kock, modified 2 Years ago.
RE: Dynamic query with accents
Liferay Legend Posts: 6403 Join Date: 9/23/08 Recent PostsJust a guess: Are you 100% super extra extra sure that your database uses UTF-8 encoding?