Words beginning with diacritics sorted oddly

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Hi Everyone, Thank your help last time. I was hoping you might be able to answer another question for me. I have a database with many words where the first letter has a diacritic. When I apply "order by" on these, the diacritic led words are sorted at the bottom instead of in their non-diacritic letter place. I could use fn:normalize-unicode but I was wondering what a "normal" sort order would be. All the best, Chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iF4EAREIAAYFAlN+Ey4ACgkQDjE+CSbP7Hrg6QD+JFvOIGYmvJ5BgIBlWNXWiFdo bryGT4xnP2amYekt9rQA/i+b7l9muugadRIvGYe0Kdie1pMwFT39n0kufC0oDueO =oe2J -----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello Chris, as you correctly observed, string comparisons within BaseX is based on unicode codepoints. However, you can define other collations, see https://docs.basex.org/wiki/Full-Text#Collations for some more details.

So, for example, something like
  for $e in ("Äa", "Ab")
  order by $e collation "?lang=de"
  return $e

will now return ("Äa", "Ab"), whereas with normal unicode ordering it would return ("Ab", "Äa"). Cheers, Dirk

- -- Dirk Kirsten, BaseX GmbH, http://basex.org |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTfhk3AAoJENiyRqgRK+WYGAsH/1QZrb6mUkJMa0voBx50CzB7 kjCalLVcrsKqrJfVQwuZACMDvJ5pq2/sSmmyhR/xvh3wCivxrjHk0VbVipHE9pZN a2UqtSsH3OsCDG6gMoVqMOo4D7RPPbncFXCsASQIlBBtGdoQkE8AwYPTw3ArlvpU pTeD+ffDPwu/Ljb+prBMr6BNoT2GMUVqKq6Ca5fcva/Y1fRHpIxjGdP2V6OgqStJ jXQxUtLPTV3Debxa9fOelYC78zhVZtDOqF4FGv/+32qEnSeFX7JK9e6/K6yA0HJO ap7ijMpEVleyNGrdvEYMufIkb5zY+qT7RPHwrb7m4RY4FXTf6yTm7M+W5ZOjcX0= =e/PS -----END PGP SIGNATURE-----