Jim Allan wrote: <snip> > > I have tried setting all language information to [none] and still cannot > get Calc to sort by Unicode order. That is, for example, ß sorts as > though it were ss, ¶ sorts before alphabetic characters, and so forth. > The symbols À, Á, Â, Ã, Ä, Å, Æ all collate between A and B. > > So I supposed that Calc uses a Unicode sort order table regardless of > language and then modifies the sort only according to whatever > particular language one uses, but never follows strict Unicode order. > > Therefore you cannot rely on a sort to use the particular value of a > character in a particular character set. Since normally one doesn't want > pure character set order, this is fine. > > Of course this doesn't explain why Ô and Õ sort differently depending on > whether they are at the beginning or middle of a string. I think that is > a bug. > > If you really do need a binary character sort, what you might do is > create a user function built on the CHAR() function which will translate > any character string into a string of digits, produce them in another > column, and then sort on that column. > > Jallan Just a further point to say that I have tried to sort with a variety of language settings (including none) and it doesn't help, nor does changing changing the field from number to text to all, etc make any difference. Jonathan -- Registerd Linux user #445917 at http://counter.li.org/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
