Re: Case sensitive

rsusanto_at_atlas-sp.com (Rudy Susanto) wrote in message news:<1a928d0b.0205071749.3562f5dd_at_posting.google.com>...
> dyou98_at_aol.com (D.Y.) wrote in message news:<f369a0eb.0205061927.56e59372_at_posting.google.com>...
> > 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.
> >
> > That's interesting. My limited SQL Server knowledge tells me it won't
> > return 'BOSTON' when you ask for 'boston'. Is there a parameter you can
> > to make it do this?
>
> When we try to install sqlserver, sqlserver allow us to change the
> default setting in the Collation Settings dialog box like
> case-sensitive/case-insensitive option. In sqlserver we can only have
> one of the case-sensitive or the case-insensitive for the instance of
> sqlserver.
>

I was only aware of an option to make object names case insensitive. But that was a long time ago. Thanks for the information.

> >
> > >
> > > 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
Received on Wed May 08 2002 - 15:41:43 CDT