Case Insensitive and Accent Insensitive searches with Oracle database (Doc ID 528070.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel System Software - Version 8.0 [20405] and later
Information in this document applies to any platform.
Product Release: V8 (Enterprise)
Version: 8.0.0.1 [20408]
Database: Oracle 10.2.0.3
Application Server OS: Microsoft Windows 2003 Server SP2
Database Server OS: Novell SUSE Linux Enterprise 9.0

This document was previously published as Siebel SR 38-3468573123.


Symptoms

Customer reported the following:

We want to know if Accent Insensitivity works for Oracle database since we have not been able to make it work with the CIAI wizard (case insensitivity works just fine). 

Please confirm if that works for you and if so help the customer understand what they did wrong.

Or get a clear answer why the accent insensitivity is not working and, if this is by design, log an Enhancement Request.

Cause

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