Re: Case sensitive

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Thu, 30 Jun 2005 19:24:11 -0700
Message-ID: <StednW0krrmSNFnfRVn-qw@comcast.com>

Serge Rielau wrote:

>>

> Hans,
>
> What about a case insensitive collation?
>
> Cheers
> Serge

Provided in Oracle Database 10g Release 1 (as are case/accent insenstive queries). Just append _CI (_AI) to the sort name used (can also be set at database level via NLS_SORT). You can also create a linguistic index

See
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10749/ch5lingsort.htm#i1009059

You will be pleased to note that we tend to use German as the example language.

<Thinks to himself> Hmmm - I wonder if I can get Serge Rielau added to the HR sample schema tables :-) </Thinks to himself> Received on Thu Jun 30 2005 - 21:24:11 CDT