How to Make the 10gR3 Content Server Use Case Insensitive Metadata Search (Doc ID 431042.1)

Last updated on MAY 23, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Oracle WebCenter Content - Version: 10.1.3.3.0 to 10.1.3.5.0   [Release: 10gR3 to 10gR3]
Information in this document applies to any platform.
***Checked for relevance on 25-Nov-2009***

Goal

When using Oracle Database as your search engine, how do you make the metadata search case insensitive?

By default, the Oracle Database is case sensitive when comparing field values. As a result, any searches against metadata are case sensitive. But for some usage scenarios, it may be important to search the metadata without regard for case.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms