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

http://x-query.com/mailman/listinfo/talk 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