Re: unicode strings are not sorted alphabetically

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Volodymyr Kostyrko <arcade(at)ints(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: unicode strings are not sorted alphabetically
Date: 2004-08-06 04:56:23
Message-ID: 20040805214931.V92438@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kris Jurka 2004-08-06 07:14:39 Re: PROBLEMS!!!
Previous Message Tom Lane 2004-08-06 00:17:30 Re: [PATCHES] [BUGS] casting strings to multidimensional arrays yields strange