Re: Case insensitive queries

From: JB <idontwantspam_at_dontwantspam.com>
Date: Mon, 24 Nov 2003 16:08:47 -0500
Message-ID: <vs4sr0oip7q23e@news.supernews.com>

Mark Townsend wrote:

> 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õ
>

Now that wasn't that hard. Thanks Mark. Note to the rest of you sexually repressed, crusty DBA's ... Instead of bashing users for asking a question and slipping in subjective ideological drivel, just answer the bloody question, perhaps with some humor.

As they say: just the facts maam, just the facts!

Thanks again Mark! Received on Mon Nov 24 2003 - 15:08:47 CST