Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Searching on case data will be case sensitive when using Oracle, because Oracle has a Case Sensitive Collation by default. Searching MSSQL is case insensitive by default when up to date with all the upgrade scripts.


The scripts for enabling or disabling case insensitive searching can be found in the dbscripts\features folder of the process-sql-store. The enable

This script creates an index which enables case-insensitive searching through lists.
To enable this feature you should run the enable script, and furthermore set the feature toggle for case insensitive search to enabled.
Like : blueriq.process-sql-store.oracle.case-insensitive-search-enabled=true

P.S. This functionality could hurt performance so use with caution.