Re: Case insensitive queries

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 24 Nov 2003 15:11:17 GMT
Message-ID: <pcpwb.94844$Dw6.466018@attbi_s02>

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õ Received on Mon Nov 24 2003 - 09:11:17 CST