Received: from sss.pgh.pa.us ([192.204.191.242])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fANGhfm63989;
	Fri, 23 Nov 2001 11:43:41 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fANGhic06353;
	Fri, 23 Nov 2001 11:43:44 -0500 (EST)
To: =?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <Frank.Koenig@rossmann.de>
cc: "'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: Re: [HACKERS] upper and lower doesn't work with german umlaut? 
In-reply-to: <70F72FD9B208D511A3DB000083693A8E406918@RS-D14> 
References: <70F72FD9B208D511A3DB000083693A8E406918@RS-D14>
Comments: In-reply-to =?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?=
	<Frank.Koenig@rossmann.de>
	message dated "Wed, 21 Nov 2001 15:15:22 +0100"
Date: Fri, 23 Nov 2001 11:43:43 -0500
Message-ID: <6350.1006533823@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200111/119
X-Sequence-Number: 2644

=?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <Frank.Koenig@rossmann.de> writes:
> uppercase umlauts are not converted.

Did you run initdb with the correct LANG environment?

To check, run contrib/pg_controldata and see what it says about
LC_COLLATE and LC_CTYPE.

			regards, tom lane