Thank you for the quick reply. But how is this usually solved?
Let's assume there is an app that accesses the same database from different countries. And in this app data should be displayed ordered. And the sort order is not identical in all countries.
Does the app have to send different SQL commands depending on the country? Not nice. Do the data have to be sorted in the app? Not nice either.
the query is the same - you just use a different COLLATE clause. For Postgres there is not any other way.