How can i build a query with accent Insensitive in clause

Hi everyone how can ignore the accent in my query ?

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?

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: