upper and lower doesn't work with german umlaut?

From: "König, Frank" <Frank(dot)Koenig(at)rossmann(dot)de>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: upper and lower doesn't work with german umlaut?
Date: 2001-11-21 14:15:22
Message-ID: 70F72FD9B208D511A3DB000083693A8E406918@RS-D14
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers pgsql-novice

hello, what is wrong?

postgresql 7.1.3
suse linux 7.1

configure postgresql:
./configure --prefix=$DIR_DEST --exec-prefix=$DIR_DEST
--enable-local --enable-multibyte
--enable-odbc --enable-syslog --with-java

init database:
$DIR_DEST/bin/initdb --pgdata=$DIR_DB01 --encoding=LATIN1

check LANG-variable:
postgres(at)server:/app/pgsql/bin > echo $LANG
de_DE

and that's the result:

my_db=# select lower('ÄäÜüÖöß');
lower
---------
ÄäÜüÖöß
(1 row)

uppercase umlauts are not converted.

thanks
frank

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Björn Lundin 2001-11-21 16:31:32 Re: Problems between Mandrake and pg
Previous Message Ryan Rohde Hansen 2001-11-21 13:44:04 Problems between Mandrake and pg

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-11-21 14:39:23 Re: SPI and CommandCounterIncrement, redux
Previous Message Thomas Lockhart 2001-11-21 14:11:14 Regression tests need updating...

Browse pgsql-novice by date

  From Date Subject
Next Message Ezra Epstein 2001-11-21 15:30:50 Oracle -> PostgreSQL ==> RAW -> ???
Previous Message Andrew Bell 2001-11-21 14:02:27 Update from a table.