I have a table with all countries of the world in 3 languages: English, Russian, Ukrainian.

The first two sorts correctly, but the Ukrainian version is not completely (as can be seen from the title).

How can this be fixed?

Thanks in advance!

    1 answer 1

    According to the official docks, there is support for the COLLATE clause for selecting character sorting.

    SELECT * FROM test1 ORDER BY a || b COLLATE "fr_FR";

    In your case (for Ukraine) will apparently

     SELECT * FROM таблица ORDER BY столбец COLLATE "uk_UA";