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>.
