Re: National Language Support sort order

[Nuno Canas]

Denver,
Denver Braughler wrote:
That is untrue for everything else.
If I want a case-blind sort, I have to store it that way.
Cache' doesn't do it for me on-the-fly.
Why should Portuguese be an exception?
I don't say that portuguese should be an exception.
But, when selecting a diferent collation some filter at database level 
should do the work on sorting depending on NLS_LANG for all the 
languages supported.
It's so easy to make an index to sort exactly the way(s) you want.
In fact, there are at least three ways to implement it.
Tell me one (the best) please.
Tnks
Nuno