cancel
Showing results for 
Search instead for 
Did you mean: 

How can i build a query with accent Insensitive in clause

henock
Ninja
Ninja

Hi everyone how can ignore the accent in my query ?

1 ACCEPTED SOLUTION

clem
Graph Steward

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:

View solution in original post

2 REPLIES 2

Joel
Ninja
Ninja

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
Graph Steward

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:

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.