General search rules

In the base configuration, PolicyCenter uses the following general rules as it performs a database search on a column that is configured to support linguistic searching:

• All searches are case insensitive, regardless of the value of the strength attribute on <LinguisticSearchCollation>.

  PolicyCenter regards the characters e and E as the same.

• All searches take punctuation into account.

  PolicyCenter regards O'Reilly and OReilly as different.

• All searches in which the strength attribute on <LinguisticSearchCollation> is set to primary ignore accent marks.

  PolicyCenter regards the characters e and è as the same.

• All searches in which the strength attribute on <LinguisticSearchCollation> is set to secondary take into account any accent marks.

  PolicyCenter regards the characters e and è as different.

PolicyCenter searches only database columns for which you set the supportsLinguisticSearch attribute to true.