Re: Sorting French Characters

You can use one these:

1. alter your session to always use french sort: alter session set nls_sort='FRENCH';
2. alter your "order by" clause in your query: select ename from emp order by nlssort(ename, 'NLS_SORT = FRENCH') ;

--
Have a nice day
Michel

Margaret Burwell <aj739_at_FreeNet.Carleton.CA> a écrit dans le message : 854qkt$ouk$1_at_freenet9.carleton.ca...
>
> I have a bilingual database created with NLS_LANG parameter of
> american_amcerica.we8pc850. When I sort a varchar2 column, the accented
> characters come at the very end. I would like the accented characters to
> immediately follow the same unaccented character. Fédération should
> follow Federation and not come after Friends or Further. At the same
> time, I do not want to chance the language to French.
>
> Can anyone suggest how I can get the database to sort they way I want?
>
> Marg
Received on Tue Jan 11 2000 - 03:18:26 CST