Database: sorting of strings different in local and official test servers

[neoheat]

Application
admin

Describe the bug
On the personal development servers, the database uses the locals from the underlaying OS. This causes a different sorting (visible in the list view of admin/inventory pools) as in the official test or productive servers.

On the personal development servers, the data entries beginning with capital letters are higher prio and therfore listed before lower case.

Example

To Reproduce

Steps to reproduce the behavior:

1. Login into personal test server
2. go to inventory pools list view
3. check sorting (example: AV-Services is sorted before Ausleihe Toni-Areal)
4. Login in offical test server
5. go to inventory pools list view
6. check sorting (example: Ausleihe Toni-Areal is sorted before AV-Services) -> which is correct
7. compare the two sortings

Expected behavior
The sorting should be as in the official test servers. The sorting should not favour capitalised letters.

Screenshots

Desktop (please complete the following information):

• Device: all
• OS & Version: all
• Browser & Version: all

[neoheat]

postgres-default is taking the local from os

solution to be further analysed

[DrTom]

[neoheat]

changed in ansible setup