How can I, for example, do a search by nodes that contains an attribute with the value of 'jose' and return the nodes that have this attribute with the 'jose' , 'josé', or 'josê' ? That is, to make the searches ignore accentuation and or cedillas, as in other databases.
Problems with accentuation in Neo4j
3
asked by anonymous 16.05.2018 / 11:59
1 answer
2
Regular Expressions
I used to play with Neo4j some time ago and remember that the names used were always treated as case-sensitive . I do not remember seeing similar collations features as 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 that you want according to the input of the user.
For example:
MATCH (n)
WHERE n.name =~ 'jos[eéê]'
RETURN n.name, n.age
16.05.2018 / 13:42