The following bug has been logged online:
Bug reference: 1330
Logged by: Özgür Çaycı
Email address: [EMAIL PROTECTED]
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 ('Güngör, Ahmet');
INSERT INTO mytable VALUES ('Güngör, Bengi');
INSERT INTO mytable VALUES ('Güngördü, Ersin');
INSERT INTO mytable VALUES ('Güngören, Bora');
INSERT INTO mytable VALUES ('Güngör, Erhan');
INSERT INTO mytable VALUES ('Güngör, Erol');
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
Özgür
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
