RE: case sensitivity - database setting?
- From: "Grant Allen" <Grant.Allen@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Aug 2005 10:46:41 +1000
On 8/8/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote:
> We are setting up an application (third-party out-of the-box type) and the
> group that is setting it up would like to set it up so that when users
> search for records the searches are NOT case sensitive.
> Is there an Oracle database setting that would facilitate this? The
> application vendor said it is a database issue and has to
> be set on the database side.
Sounds like your 3rd-party vendor has done a kludge to port from SQL Server or
Sybase, and hasn't really got a clue about this sort of thing. Ask them for
Oracle reference sites ... see what pain other people have experienced.
(And yes, I work for company that gets it right when porting :-) ).
Ciao
Fuzzy
:-)
----------------------------------
"Everything you think, do, and say
was in the pill you took today."
-- Zager and Evans
--
//www.freelists.org/webpage/oracle-l
Other related posts:
