Re: Problem with Order by in French

In french, non-alphanumeric character are ignored in sort. More, in Oracle, when two "words" have the same rank, a binary sort is made (and in your list #Test is before TEST).

--
Have a nice day
Michel

Carl Shamie <carls_at_videotron.ca> a écrit dans le message : BKxc4.1602$Bu1.53052_at_wagner.videotron.net...
> Hello,
>
> We are currently working on designing and using an Oracle 8.0i database
> for an e-commerce web site. We are having a small glitch! When we use the
> ORDER BY function we never get a good sorting of the names. Here is an
> example of the problem.
>
> AB
> af
> Épicerie
> TEST
> #Test
> tintin
> 4u all
>
> Now as you see the numbers are at the end : That`s correct.
> Why is the pound sign between two "T". Does Oracle drop the first character?
> We have done the following settings :
>
> alter session set nls_language = french;
> alter session set nls_sort = french;
>
> Why do we need french? Cause the site must be bilingual and french has
> a lot of accents on letters which are not sorted right without these
> settings!
>
> Can anybody help us on this one? Is there a setting that we overlooked?
>
> Thank you
>
> Carl S.
> Java/Web developper
>
>
Received on Wed Jan 05 2000 - 05:41:46 CST