SqlPredicate query is case sensitive or insensitive

[chinna]

Is SqlPredicate query of string expressions is case sensitive or insensitive?

If it is case sensitive, is there a way in query to add ignore case for string expression.

Issue is user provides in data in case in sensitive when search with same data its not working looks like its case sensitive 'abC' is different from 'ABc' 

Please help me.

Thanks in advance

[Jaromir Hamala]

Hi,

if you = or == for comparison then I believe it's case sensitive. 

You can use the 'ilike' or the 'regepx' operators instead of the = . See this for example on syntax: 

https://github.com/hazelcast/hazelcast/blob/master/hazelcast/src/test/java/com/hazelcast/query/SqlPredicateTest.java

Cheers,

Jaromir