Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: case sensitivity - database setting?
On 8/8/05, J. Dex <cemail_219_at_hotmail.com> 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
:-)