Received: from rs-mail1.rossmann.de ([62.48.68.149])
	by postgresql.org (8.11.3/8.11.4) with SMTP id fALEFam40171;
	Wed, 21 Nov 2001 09:15:37 -0500 (EST)
	(envelope-from Frank.Koenig@rossmann.de)
Received: by RS-D14 with Internet Mail Service (5.5.2653.19)
	id <WWNA3JYM>; Wed, 21 Nov 2001 15:15:23 +0100
Message-ID: <70F72FD9B208D511A3DB000083693A8E406918@RS-D14>
From: =?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <Frank.Koenig@rossmann.de>
To: "'pgsql-novice@postgresql.org'" <pgsql-novice@postgresql.org>,
	"'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>,
	"'pgsql-hackers@postgresql.org'" <pgsql-hackers@postgresql.org>
Subject: upper and lower doesn't work with german umlaut?
Date: Wed, 21 Nov 2001 15:15:22 +0100
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id
	fALEVvo40704
X-Archive-Number: 200111/118
X-Sequence-Number: 2643

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@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