Problems with accents in Neo4j

Question:

How can I, for example, search for nodes that contain an attribute with the value of 'jose' and return nodes that have that attribute with the value of 'jose', 'jose', or 'jose' ? That is, make searches ignore accents and/or cedillas, as in other databases.

Answer:

regular expressions

I played with Neo4j some time ago and I remember that the names used were always treated as case-sensitive . I don't remember seeing collations functionality like SQL databases.

Anyway, according to this Neo4j documentation , you can use regular expressions in your queries . In your case you would need to specify the possible accents you want according to user input .

For example:

MATCH (n)
WHERE n.name =~ 'jos[eéê]'
RETURN n.name, n.age
Scroll to Top