Case Insensitive

[myrights99]

Hello:

Currently, I am working Graph data model and soon going to ETL data from Snowflake. I want to make my Neo4j Graph Database properties case insensitive so that I can query MATCH without worrying about case sensitivity.

Any help setting up or configuring case insensitive at the creation of the Database or for all nodes\relationships properties is greatly appreciated.
Thanks.

[glilienfield · Accepted solution]

Neo4j is case sensitive.  You could save your string properties as lower case when loading your data using 'toLower()' on each.  Then, you just need to make sure your matching string is lower case.  You can also use case insensitive grep string searches by prepending your search string with '(?i)'

[glilienfield · Accepted solution]

Neo4j is case sensitive.  You could save your string properties as lower case when loading your data using 'toLower()' on each.  Then, you just need to make sure your matching string is lower case.  You can also use case insensitive grep string searches by prepending your search string with '(?i)'

[ameyasoft · Accepted solution]

Only approach is to use 'toLower' function in your queries. Say a Person node has a property 'name' = "JoHn". The query:
MATCH (a:Person) WHERE toLower(a.name) = toLower("jOhN"). This will return the Person node.

[myrights99]

Thank you all for your answers; I am from an SQL Server background, so I was looking for a similar configuration.
Thank you again.