Skip site navigation (1) Skip section navigation (2)

Re: BUG #1330: Incorrect String Order By In tr_TR Locale

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: Özgür Çaycı <ozgur(at)cayci(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1330: Incorrect String Order By In tr_TR Locale
Date: 2004-11-26 16:32:17
Message-ID: Pine.LNX.4.61.0411261828110.29733@emo.org.tr (view raw or flat)
Thread:
Lists: pgsql-bugs
  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

--8323328-739246297-1101486737=:29733
Content-Type: TEXT/PLAIN; charset=iso-8859-9; format=flowed
Content-Transfer-Encoding: 8BIT

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Fri, 26 Nov 2004, PostgreSQL Bugs List wrote:

> I use 8.0 Beta-5.
>
> I am using a PostgreSQL cluster which I have created with locale tr_TR. When
> I use "Order By", the strings are not ordered correctly. The spaces are
> ignored when I use "Order By" clause. Here is a sample SQL dump to re-create
> this situation:

<snip>
> When I try 'Select * FROM mytable ORDER BY mytext ASC'
>
> I get the following output:
>
> Güngör, Ahmet
> Güngör, Bengi
> Güngördü, Ersin
> Güngören, Bora
> Güngör, Erhan
> Güngör, Erol
>
> The expected result is as follows:
>
> Güngör, Ahmet
> Güngör, Bengi
> Güngör, Erhan
> Güngör, Erol
> Güngördü, Ersin
> Güngören, Bora


Upgrade to latest glibc. Debian unstable does not have this problem.
http://sources.redhat.com/cgi-bin/cvsweb.cgi/libc/localedata/locales/tr_TR?cvsroot=glibc

See

http://yunus.listweb.bilkent.edu.tr/Linux/linux-programlama/2004/May/0061.html
and all mails in the thread for more information.

Regards,
- --
Devrim GUNDUZ 
devrim~gunduz.org				devrim.gunduz~linux.org.tr
 			http://www.tdmsoft.com
 			http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBp1qStl86P3SPfQ4RAncwAJ9hXpZjz7FF3I/LgEKrVFqhvbbtVgCgtvsl
89QTPJs/hMk2jY292mGY8Iw=
=kPSL
-----END PGP SIGNATURE-----
--8323328-739246297-1101486737=:29733--

In response to

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2004-11-26 17:38:25
Subject: Re: Version control for DLLs installed into WINNT/system32
Previous:From: PostgreSQL Bugs ListDate: 2004-11-26 16:25:14
Subject: BUG #1330: Incorrect String Order By In tr_TR Locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group