The sorting of Oracle using XGERMAN_CI or just GERMAN isn’t correct, as it doesn’t respect umlauts. Umlauts are used just as a tiebreaker if there isn’t another difference between the sorted values.

Therefore, sorting by familynames ‘Pohl’ and ‘Pöhl’, ‘Pöhl’ as to be sorted later (higher), but if you include the first names like ‘Cindy’ and ‘Karl’, using familyname||firstname (as opposed to familyname, firstname, Cindy comes before Karl.

Is there a way to get this sorting correctly?