I'm on Oracle 10gR1 and Remedy 6.3 and is running into the same
requirements. I have a very crude way to search the Summary field using an
Active Link. I'm only piloting it right now with our HelpDesk staff and they
said it's totally better than nothing. I wish to expand on it since it seems
to wor
Full Text Search will also meet your needs. This was reinstated with ARS 7.
-Original Message-
From: William H. Will Du Chene <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thu, 24 Apr 2008 1:44 pm
Subject: Re: Oracle Case insensitive search:any proven easy way?
SQL Server i
SQL Server is case insensitive by default.
With Oracle, you need to perform a linguistic sort.
alter session set NLS_SORT=BINARY_CI;
alter session set NLS_COMP=LINGUISTIC;
> We have implemented Remedy ITSM 7.1 on Oracle.
> Customer needs case insensitive searches!!
> is there any way other tha
Build workflow to set all to upper on submit and search
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of surya4u
Sent: Thursday, April 24, 2008 2:16 PM
To: arslist@ARSLIST.ORG
Subject: Oracle Case insensitive search:any proven
We have implemented Remedy ITSM 7.1 on Oracle.
Customer needs case insensitive searches!!
is there any way other than using ALTER SESSION query,because there is
proven performance impact.
Best way is to go for SQL SERVER??
anyone know about easy way in oracle to make case insensitive search?anyon
5 matches
Mail list logo