order UTF-8 encoded StringsJohn Snelson john.snelson at oracle.com
Wed Feb 27 11:03:00 PST 2008
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
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format