Re: unicode strings are not sorted alphabetically - Mailing list pgsql-bugs

On Sat, 31 Jul 2004, Volodymyr Kostyrko wrote:

>    This applies to non-english strings (in my case - russian). I've
> stumbled upon it on version 7.3.4. ( PostgreSQL 7.4.3 on
> i386-portbld-freebsd5.2.1, compiled by GCC cc (GCC) 3.3.3 [FreeBSD]
> 20031106)

What locale and server encoding was the server configured with?

I get a different result using -E UNICODE and ru_RU.UTF8 but still not in
id order, (2,1,3,5,4,6,7,8,9,13,10,11,12,16,14,17,18,15,19,20,21,22,23).
Do you get a different order from the unix sort command?