The procedure for creating database indexes differs, based on whether case-insensitive
search behavior is in effect. You can use the administration console to create supporting
indexes in most circumstances.
Content Platform Engine implements case-insensitive search behavior by
including the
LOWER function on the property and on the string value in query
statements, so that the search condition becomes
LOWER(property)=LOWER('Value').
However, for the following databases, the administration console cannot create supporting
indexes in this way because the
LOWER function is not supported on a column
in an index.
- For DB2® for Linux, UNIX and Windows before 10.5, a generated column must
first be created and then indexed so that the performance of the search is good.
- For SQL Server, a case-insensitive collation is the default collation. If you use this
collation, there is no need to enable case-insensitive search on the object store.
Therefore, disable the Force case-insensitive search object store
setting in the administration console. See Setting case-insensitive search behavior for object store searches.