| Greetings Starting from version 12.0 official docker image switched from Debian-stretch to Debian-bullseye and from that point we have a huge pain with sorting issues on Russian collation. Dockerfile: FROM postgres:14 RUN apt-get clean && apt-get update && apt-get install -y locales RUN localedef -i ru_RU -c -f UTF-8 -A /usr/share/locale/locale.alias ru_RU.UTF-8 ENV LANG ru_RU.utf8 postgres=# select version(); version ----------------------------------------------------------------------------------------------------------------------------- PostgreSQL 14.0 (Debian 14.0-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit Issue: postgres=# SELECT * FROM unnest(ARRAY ['ея', 'ёа']) name ORDER BY name; name ------ ёа ея (2 строки) еqя should go before ёqа postgres=# SELECT 'ея' COLLATE "ru_RU" < 'ёа' COLLATE "ru_RU"; ?column? ---------- f (1 строка) And should be TRUE here Any idea how to fix that? We are not able manage this for 3 years already ((( |
