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

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

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

ah(at)ahb:~$ LC_ALL=da_DK initdb
ah(at)ahb:~$ su postgres -c "/usr/local/pgsql/bin/createuser -ad ah"
ah(at)ahb:~$ createdb ah
ah(at)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 ;-)