Re: Case insensitive queries

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 24 Nov 2003 16:25:28 GMT
Message-ID: <bptbdo$1s22u1$1@ID-82536.news.uni-berlin.de>

Thanks a lot, Mark

Rene

> Rene Nyffenegger wrote:

>>  
>> 
>>>FYI - case insensitivity, as a database/session/query parameter, is 
>>>supported in Oracle Database 10g, coming soon.
>> 
>> 
>> This is interesting, because I was asked that very question less than
>> three days ago and didn't know that it's going to be possible
>> with 10g. Does someone already know more details about it, such
>> as parameter name and the like. I'd think it'll be something like
>> alter session set sql_case_sensitivity=false
>> or so. 
>> 
>> Thanks,
>> Rene
>> 
>> 

>
> New NLS_SORT and NLS_COMP parameters. Note that accent and case
> insensitivity are supported.
>
> ALTER SESSION SET NLS_SORT=generic_m_ai;
> ALTER SESSION SET NLS_COMP=ansi;
>
> SELECT cust_last_name
> FROM customers
> WHERE cust_last_name = 'De Niro';
>
> CUST_LAST_NAME
> -----------------------
> de Niro
> De Niro
> dë nirõ
>

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch

Received on Mon Nov 24 2003 - 10:25:28 CST