[xquery-talk] order UTF-8 encoded Strings

[John Snelson]

Hi Gonz,

The "correct" answer is to use a collation - either a German specific 
one or a case and diacritic insensitive one. Since the mechanism for 
providing collations is implementation defined, how this is done will 
depend on what XQuery engine you are using.

John

gonzberg at gmx.de wrote:
> Hi all,
> I retrieve UTF-8 encoded Strings from my database with this XQuery:
> 
> for $x in //text/country order by xs:string($x) ascending return xs:string($x)
> 
> This is the result, it is not ordered like I expected:
> 
> Deutschland
> Italia
> Oabcde
> Ägypten
> Österreich
> 
> Is this the correct order according to a default collation? How would I order it like this (which would be standard for German language):
> 
> Ägypten
> Deutschland
> Italia
> Oabcde
> Österreich
> 
> Thanks a lot, Gonz
> 
> 


-- 
John Snelson, Oracle Corporation            http://snelson.org.uk/john
Berkeley DB XML:        http://www.oracle.com/database/berkeley-db/xml
XQilla:                                  http://xqilla.sourceforge.net