Case Insensitive - Oracle

1 posts, 0 answers
  1. Ziti
    Ziti avatar
    1 posts
    Member since:
    Aug 2016

    Posted 24 Aug Link to this post

    Hi,

    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.


Back to Top