It sounds like you need to change the language used for collation. Documentation on how to do that
can be found at:
http://platinum.intersystems.com/csp/docbook/DocBook.UI.Page.cls?KEY=ANLS_Collation
And my response is : <quote>
Yes, it seems like what I need. But not clear to me !!!
In Oracle (that I know), for instance, you have variables like NLS_COLLATION that defines what kind of collation you are using.
In Cache you should have something like that, I mean independent of what you set-up on your database setup but dependent on language you are using.
I don't want ASCII sort but Dictionary sort.
On the same application if I set-up the language to be en_US the sort order can be diferent.
Of course it should meet my application preferences.
Resuming, I don't want to change the Globals sort order but it should meet my application/browser/anything preferences.
The Globals is the way Cache stores data (I don't need to "Know" that) I just want to know how to retreive it the way I need. (like $zd(+$h,4) the way I want the date format).
Is it possible ?
Nuno
</quote>
Denver Braughler wrote:
Nuno Canas wrote:
Yes !! The collation is what I meant !
The MDC was working on this before the big gulp 6+ years ago.
I forwarded this question to support and I'm still waiting for News.
I think you can be optimistic.
<http://platinum.intersys.com/csp/docbook/DocBook.UI.Page.cls?KEY=RGOT_A2F>
Collation Sequence -
Specifies the order in which Cache' retrieves global nodes, when it must retrieve nodes in order. A character set and a collation rule together make up a collation sequence.
Each global is associated with a particular collation sequence.
w $zu(49,databasefile,13)
