[xquery-talk] order UTF-8 encoded Strings

gonzberg at gmx.de gonzberg at gmx.de
Wed Feb 27 12:45:32 PST 2008


Thanks John,
ok, that was easy...

Gonz


-------- Original-Nachricht --------
> Datum: Wed, 27 Feb 2008 11:03:00 +0000
> Von: John Snelson <john.snelson at oracle.com>
> An: gonzberg at gmx.de
> CC: talk at x-query.com
> Betreff: Re: [xquery-talk] order UTF-8 encoded Strings

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

-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger


More information about the talk mailing list