Sort query results with German umlaut

Question

Is it possible to sort the results of a cypher query, including German umlaut, for example, ä, ö, ü? At the moment, I get the list in alphabetical order, and nodes starting with umlaut are placed at the end of the list. Usually they should be on the list, for example. "Ö" must be equal to "OE".

Any ideas are welcome, thanks.

Answer 1

Since you asked specifically about Cypher, the following query is an example of how to sort umlaut characters as if they were their ligature equivalents (for example, treating “Ü” as if it were “UE”).

WITH ['Dorfer', 'Dörfener'] AS names
UNWIND names AS name
RETURN name
ORDER BY
  REDUCE(s = name, x IN [
    ['ä', 'ae'], ['Ä', 'AE'],
    ['ö', 'oe'], ['Ö', 'OE'],
    ['ü', 'ue'], ['Ü', 'UE']] |
    REPLACE(s, x[0], x[1]));

"Dörfener", "Dorfer" - .

, REPLACE name. Java, names .

Answer 2

, localeCompare Intl. Collator :

// Our original array
// Outputs ["u", "x", "ü", "ü", "ü"]
const input1 = ['ü','u','ü','x','ü'];
const output1 = input1.sort();
console.log(output1);

// Intl.Collator
// Outputs ["u", "ü", "ü", "ü", "x"]
const input2 = ['ü','u','ü','x','ü'];
const output2 = input2.sort(Intl.Collator().compare);
console.log(output2)

// localeCompare
// Outputs ["u", "ü", "ü", "ü", "x"]
const input3 = ['ü','u','ü','x','ü'];
const output3 = input3.sort(function (a, b) {
    return a.localeCompare(b);
});
console.log(output3)