when I do a select with ORDER BY I get a wrongly sorted list back.
Here my systems details:
SuSE Linux 7.3
contains readline, history, multibyte support
initdb -E UNICODE
table NAME with fields id and name
If I do a
select * from NAME order by name;
I get the following output:
which is not the right order (it should look like above).
When I can the encoding in psql to LATIN1 I still get the same wrong result.
My LC_ALL and my LC_COLLATE are both set to de_DE.
What did I do wrong here???
pgsql-novice by date
|Next:||From: Henk Schets||Date: 2002-07-17 11:36:43|
|Subject: special accents in text columns|
|Previous:||From: Rasputin||Date: 2002-07-17 09:15:34|
|Subject: Re: Problems linking to libpq|