The sorting issue is caused by the locale of the database. This locale isn't set in XWiki, it needs to be specified when creating the database. I've updated the instructions on [https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/InstallationWAR/InstallationPostgreSQL/] to create databases with the correct encoding.
Using the locale "C" or "C.UTF-8" works. "C.UTF-8" seems better in the sense that it also supports uppercase/lowercase transformations for non-ASCII characters.
Unfortunately, the locale cannot be changed after the database has been created. Therefore, the only fix for existing installations is to dump and re-create the database.
Things to check and do: # (Done, settings updated) Can/do we set the correct locale for integration tests, also to verify that everything works correctly with the recommended locale? # Can we make sure that the Debian package creates the database with the correct locale? # Update the instructions in the Docker README.
This message was sent by Atlassian Jira (v9.3.0#930000-sha1:287aeb6)
If image attachments aren't displayed, see this article.