Configuring search in the PolicyCenter database

For a column to be eligible for inclusion in the database search algorithm, the supportsLinguisticSearch attribute on that column must be set to true. Setting this column attribute to true marks that column as searchable and supports case insensitive searches, regardless of which DBMS you use.

Note: Setting this attribute to true on a column makes it possible to do case-insensitive search on a denormalized version of the column. Setting it to false enables binary search on the column itself, as described in Linguistic search and sort. Setting this attribute does not affect language or locale for searches. Using locale in searching and collation order are controlled by the configuration of the user's locale and the strength of the LinguisticSearchCollation entry in the language_languageCode.xml file.

Important: You cannot use the supportsLinguisticSearch attribute with an encrypted column. If you attempt to do so, the application server cannot start.

How Guidewire PolicyCenter handles searching of data depends on the database involved.