Hi list,
we are currently migrating a ARS application from Sybase to Oracle
10gR2. A big problem is that Oracle by default is case sensitive and
users are used to execute searches without caring about the case.
We applied KM-000000012018 without great success.
We also played around with the following Oracle options:
ALTER SESSION SET NLS_COMP=LINGUISTIC;
ALTER SESSION SET NLS_SORT=BINARY_CI;
and function based indexes to get Oracle to work case insensitive. The
problem is that the indexes created by ARS won't work and performance
would be very poor.
Does anybody have a performant real live environment with ARS using
Oracle case insensitivity options and would like to share the details?
Remedy support says this is a limitation from Oracle.
Oracle support states that everything works great if you use
nlssort-funcion in the where clause of your SQL statement. Unfortunately
ARS doesn't issue SQL commands of that style.
ARS 7.0.0
Oracle 10gR2
Solaris 10
Kind regards,
Albert
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
