Searching and the Oracle database

To implement linguistic searching in Oracle, the database compares binary values that PolicyCenter modifies for searching. For functional and performance reasons, PolicyCenter does not use Oracle collations.

• For primary, accent-insensitive searching, Guidewire uses the configurable Java class described in Configuring Oracle search in collations.xml to compute the comparison values. Guidewire also uses this Java class to define the search semantics for searching in the Japanese and German languages.
• For secondary, case-insensitive searching, Guidewire transforms the search values to lower case.