Content Management and Capture

 View Only
Expand all | Collapse all

Force Case Insensitive search option

  • 1.  Force Case Insensitive search option

    Posted Thu May 13, 2021 12:08 PM
    Hi, I have enabled Force Case Insensitive search option in objectstore->properties->query tab.
    so Ideally all the generated queries should have Lower function in where clause but when checked the database logs we observed that in some queries UPPER function is there and in some queries it is LOWER because of the queries which are using UPPER are taking lot of time. (in DB2 - Indexes are created using LOWER)

    Please help me to fix this weird issue.

    Regards,
    Pankaj

    ------------------------------
    Pankaj Gupta
    ------------------------------


  • 2.  RE: Force Case Insensitive search option

    Posted Fri May 14, 2021 08:32 AM
    Although UPPER is applied in some internally generated queries it is not applied to the database query for user searches unless that expression is used explicitly in the incoming (API) CE SQL. So these queries must be coming from some application and you would have to identity what and why. If you post the actual query you might get some help here on making that identification.

    ------------------------------
    Mike
    ------------------------------