Setting case-insensitive search behavior for object store searches

You can configure the property value comparisons in query search conditions to be performed in a case-insensitive manner.

About this task

Restriction: Forced case-insensitivity has no effect on content-based retrieval (CBR) search functions.
Important:
  • Some databases automatically enable case-insensitive search behavior; others must be enabled. See Creating database indexes for class properties (case-insensitive search) for information.
  • For optimal query performance, you might need to create different types of database indexes if you change the way that case-insensitive search behavior is configured. For more information, see Creating database indexes for class properties.
  • You cannot force search behavior to be case-sensitive: in the absence of forced case-insensitivity, property value comparisons operate in a manner that is determined by the configured behavior of the underlying database. This underlying behavior might be case-insensitivity.

Procedure

To set case-insensitive search behavior:

  1. Access the Query tab in the administration console:
    1. In the domain navigation pane, click the object store.
    2. In the details pane, click the Query tab.
  2. Select the Force Case Insensitive Search check box.
  3. Save your changes.