I just discovered that ORDER BY TO_CHAR(nome) Makes what I need.
Nuno
Denver Braughler wrote:
Nuno Canas wrote:
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.
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 does provided that you specify it for the global or database. No?
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.
What is best depends on the situation.
Probably I would make an index that combines case-folding and diacritic collapse using $zcvt() <http://platinum.intersys.com/csp/docbook/DocBook.UI.Page.cls?KEY=ANLS_Translation>.
