Thread

1. BUG #1330: Incorrect String Order By In tr_TR Locale

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2004-11-26T16:25:14Z

   The following bug has been logged online:
   
   Bug reference:      1330
   Logged by:          zgr ayc
   
   Email address:      ozgur@cayci.org
   
   PostgreSQL version: 8.0 Beta
   
   Operating system:   Debian Woody
   
   Description:        Incorrect String Order By In tr_TR Locale
   
   Details: 
   
   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: 
   
   CREATE TABLE mytable (
       mytext character varying(255)
   );
   
   INSERT INTO mytable VALUES ('Gngr, Ahmet');
   INSERT INTO mytable VALUES ('Gngr, Bengi');
   INSERT INTO mytable VALUES ('Gngrd, Ersin');
   INSERT INTO mytable VALUES ('Gngren, Bora');
   INSERT INTO mytable VALUES ('Gngr, Erhan');
   INSERT INTO mytable VALUES ('Gngr, Erol');
   
   When I try 'Select * FROM mytable ORDER BY mytext ASC'
   
   I get the following output:
   
   Gngr, Ahmet
   Gngr, Bengi
   Gngrd, Ersin
   Gngren, Bora
   Gngr, Erhan
   Gngr, Erol
   
   The expected result is as follows:
   
   Gngr, Ahmet
   Gngr, Bengi
   Gngr, Erhan
   Gngr, Erol
   Gngrd, Ersin
   Gngren, Bora
   
   zgr
   
   
   
   
   
   

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

   Devrim Gündüz <devrim@gunduz.org> — 2004-11-26T16:32:17Z

     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--