Hi,
The workaround is to use UPPER SQL function:
var _arg = new object[] { "%ABC%" };
new SqlQuery(typeof(CustomerModel), "UPPER(CustomerName) like ?", _arg)
Pavel
On Wed, Aug 22, 2018 at 12:15 PM Evgenii Zhuravlev <[email protected]>
wrote:
> Hi,
>
> As for now, Ignite SQL is case-sensitive. There are plans to
> support case-insensitive search in SQL in future, here is the ticket:
> https://issues.apache.org/jira/browse/IGNITE-3999
>
> Evgenii
>
> ср, 22 авг. 2018 г. в 12:04, shuvendu <
> [email protected]>:
>
>> Hi,
>>
>> How to make apache ignite sqlquery to ignore case.
>>
>> for example
>>
>> var _arg = new object[] { "%abc%" };
>>
>> new SqlQuery(typeof(CustomerModel), "CustomerName like ?", _arg)
>>
>> var _arg = new object[] { "%ABC%" };
>>
>> new SqlQuery(typeof(CustomerModel), "CustomerName like ?", _arg)
>>
>> i am getting different results in both the cases
>>
>> Thanks
>>
>> Shuvendu
>>
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>
