Case insensitive will work SAP HANA CLOUD Database

[former_member804841]

Hi,

IS there is any option of "Case insensitive work SAP HANA CLOUD Database" ??

We are working in different databases like Oracle,MSSQL,MYSQL, these are all have an option of Case insensitive of the database, But we are not found any option like this in the SAP HANA CLOUD database.

Issue : Using Java Application.

While we are using any search criteria in the query we direct pass the Insensitive data we are passing. But it is not working in the SAP HANA Cloud database. We can also use UPPER case both and check but in our application we are using lot of places as insensitive search.

Can you please suggest how can we resolved the issue.

For Example : Select * from employees where empnm like ‘%Naresh%’

It should work by given %NARESH% (OR) %naresh% (OR) %Naresh% OR ‘%NaResh%’ scenarios

[Javier-Martin · Accepted solution]

There is a session parameter for this I have used before, may it be valid for you too ?:

SET SESSION 'CASE_SENSITIVE' = 'FALSE'

Regards.

[Cocquerel]

You could use predicate LIKE_REGEXPR instead of LIKE, there is an option to enable case-insensitive matching.
See https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/b40d483dd34d47aa9cc89b4...