Re: 'order by' does "wrong" with unicode-chars (german umlauts)

Sat, 20 Sep 2003 18:39:35 +0200
skrev pilsl@goldfisch.at (peter pilsl):

> It makes no difference if I use a database with encoding unicode:
>

ah@ahb:~$ LC_ALL=da_DK initdb
ah@ahb:~$ su postgres -c "/usr/local/pgsql/bin/createuser -ad ah"
ah@ahb:~$ createdb ah
ah@ahb:~$ psql ah

ah=# \l

        List of databases
   Name    |  Owner   | Encoding
-----------+----------+-----------
 ah        | ah       | SQL_ASCII


ah=# show client_encoding;

 client_encoding
-----------------
 SQL_ASCII
(1 row)


CREATE TABLE test (f1 varchar);

INSERT INTO test VALUES ('A');
INSERT INTO test VALUES ('B');
INSERT INTO test VALUES ('AA');
INSERT INTO test VALUES ('Æ');
INSERT INTO test VALUES ('Å');
INSERT INTO test VALUES ('Ø');
INSERT INTO test VALUES ('Ä');
INSERT INTO test VALUES ('Ö');
INSERT INTO test VALUES ('Ü');

SELECT * FROM test ORDER BY f1;

 t
----
 A
 B
 Ü
 Æ
 Ä
 Ø
 Ö
 Å
 AA
(9 rows)


Looks OK to me  ;-)