How can i build a query with accent Insensitive in clause

[henock]

Hi everyone how can ignore the accent in my query ?

[Joel]

Hi henock, Could you share your query, and give a little more information about what you are trying to do?

for example

• I'm guessing you have one or more special characters in a string field, OR in the WHERE clause search text?
• and you might mean, to silently (remove)/ignore all occurrences during a comparison/search?

[clem · Accepted solution]

I think you'd have to make an extension that calls a unicode string function that strips the accents.

Currently, there doesn't appear to be any such function currently in APOC.

See:

stackoverflow.com

Is there a way to get rid of accents and convert a whole string to regular letters?

java, string, diacritics

asked by Martin on 08:33PM - 23 Jul 10 UTC