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

Devrim GUNDUZ Fri, 26 Nov 2004 08:37:23 -0800

-----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-----
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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

Reply via email to