You can configure the property value comparisons in query
search conditions to be performed in a case-insensitive manner. (You
cannot, however, 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.)
About this task
Restriction: Forced case-insensitivity has no
effect on content-based retrieval (CBR) search functions.
Important: - For a SQL Server database, case-insensitive search behavior is
best achieved by using a case-insensitive collation at the database
level. Do not follow this procedure to set it at the P8 level.
- 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.
Procedure
To set case-insensitive search behavior:
- Access the Query tab in the administration console:
- In the domain navigation pane, click the object store.
- In the details pane, click the Query tab.
- Select the Force Case Insensitive Search check
box.
- Save your changes.