Postgresql ordering is broken in Alpine Docker images
Hello,
we've recently tried switching from Debian based postgres images to Alpine based ones, but apparently the sorting in Alpine postgres is different than in the Debian based images (possibly due to musl locale support?).
On Debian this query: SELECT unnest(array['a','o','ä_kl', 'ö', 'oe', 'od', 'of', 'A', 'Ä_gr', 'O', 'Ö', 'ä', 'Ä', 'Müll', 'Muzin', 'Münze', 'e', 'é', 'f', 'ß', 'ss', 's', 'st' ]) ORDER BY 1;
returns this:
a
A
ä
Ä
Ä_gr
ä_kl
e
é
f
Müll
Münze
Muzin
o
O
ö
Ö
od
oe
of
s
ss
ß
st
(23 rows)
On Alpine it returns this:
A
Muzin
Müll
Münze
O
a
e
f
o
od
oe
of
s
ss
st
Ä
Ä_gr
Ö
ß
ä
ä_kl
é
ö
(23 rows)
Both databases are set up with de_DE.utf-8
as Collate and Ctype.