We are currently using Telerik Data Access to connect to a Oracle database and I am trying to get case insensitive queries to work.
If I run the following query directly on the database, I get the results I want:
ALTER SESSION SET NLS_SORT=BINARY_CI;
ALTER SESSION SET NLS_COMP=LINGUISTIC;
SELECT * FROM ... WHERE FIELD = 'CaseDoesntMatter'
I tried add the above alter statements to the backend configuration using the following:
backendConfiguration.ConnectionPool.InitSQL.Add("ALTER SESSION SET NLS_SORT=BINARY_CI");
backendConfiguration.ConnectionPool.InitSQL.Add("ALTER SESSION SET NLS_COMP=LINGUISTIC");
However, running the above results in an exception:
"ORA-01013: user requested cancel of current operation"
If I run either statement individually I don't get the exception, however the queries performed are still not case insensitive.
Any assistance with this issue would be appreciated.