Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case sensitive
rsusanto_at_atlas-sp.com (Rudy Susanto) wrote in message news:<1a928d0b.0205060152.467b9d26_at_posting.google.com>...
> Hi All,
>
> I need some suggestions about case sensitive implementation.
>
> SQL> select * from dept;
> DEPTNO DNAME LOC
> ---------- -------------- -------------
> 10 ACCOUNTING NEW YORK
> 20 RESEARCH DALLAS
> 30 SALES CHICAGO
> 40 OPERATIONS BOSTON
>
> SQL> select * from dept where loc='boston';
> no rows selected
>
> I realise that i have to modified the query according to the oracle
> way.
> I know about the oracle behavior but i don't know the good way to
> apply to the production.
> Right now we choose another database like oracle as our database but
> we have a little problem about case sensitive, as long as we use
> sqlserver we never met this problem.
>
> May be there are some tricks to solve this problem that i can apply:
> 1. create trigger to each table to convert every text into upper case,
> or
> 2. always use upper case on front-end to make sure the data in upper
> case
> 3. or the others
>
> As addition information we use clarion as our front-end.
>
> Is there a way to change the oracle setting that allow us ignore about
> the case sensitive? so we do not need to use the upper function.
>
>
> Thank in advance,
>
> Rudy Susanto
I do not think there is a way apart from the methods you rightly mentioned Michael Tubuo Ngong(Sr DBA) Received on Mon May 06 2002 - 10:53:01 CDT