Oracle 10.2 [or higher] does support true case-insenstiveness. I was
informed from a DBA that two session variables must be set for any
connection made to the database to allow case-insensitive searches:
ALTER SESSION SET NLS_SORT=BINARY_CI
ALTER SESSION SET NLS_COMP=LINGUISTIC
One way of setting this is to have a "Logon" trigger for the user
ARAdmin, which will set these sesion variables.
Also for performance issue, case-sensitive indexes will have to
created on frequently-searched fields. Since, there is no option
specifying any database parameters during creating indexes for forms
usin the Remedy Admin Tool, these indexes have to be manually created
by the DBA
Regards,
Sumeet Das
On Oct 29, 1:56 pm, Axton <[EMAIL PROTECTED]> wrote:
> Since we are now on 10gR2, this is something I will be exploring in
> the near future. I plan to document my findings and experiences on
> arswiki.org. It will probably be early 2008 before I get too deep
> into it though.
>
> Axton Grams
>
> On 10/29/07, Emad Zaky <[EMAIL PROTECTED]> wrote:
>
> > **
> > Hello Listers,
>
> > Has anyone managed to run AR 7.0.1 on Oracle 10g with case insensitivity on?
> > I would like to share the experience.
>
> > Regards,
> > Emad __20060125_______________________This posting was
> > submitted with HTML in it___
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the
> Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
