X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id 194EE9257A4
	for <pgsql-sql@postgresql.org>; Sun, 25 May 2003 14:22:24 -0400 (EDT)
Received: from developer.postgresql.org ([64.117.224.193])
	by localhost (developer.postgresql.org [64.117.224.193:10024])
	(amavisd-new) with ESMTP id 90630-04 for <pgsql-sql@postgresql.org>;
	Sun, 25 May 2003 14:22:22 -0400 (EDT)
Received: from saphir (dsl-213-023-150-132.arcor-ip.net [213.23.150.132])
	by developer.postgresql.org (Postfix) with ESMTP id 4E0F69257A0
	for <pgsql-sql@postgresql.org>; Sun, 25 May 2003 14:22:22 -0400 (EDT)
Received: by saphir (Postfix, from userid 1000)
	id 6BE361315D0; Sun, 25 May 2003 20:22:18 +0200 (CEST)
Subject: Re: select =?ISO-8859-1?Q?lower=28'=C6=D8=C5?= ABC'); does
From: Markus Bertheau <twanger@bluetwanger.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <2862.1053832051@sss.pgh.pa.us>
References: <1kqza.10221$YZ6.333198@news010.worldonline.dk>
	<2862.1053832051@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Message-Id: <1053886937.28728.1.camel@saphir>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.3.3 (Preview Release)
Date: 25 May 2003 20:22:17 +0200
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/488
X-Sequence-Number: 13653

=D0=92 =D0=92=D1=81=D0=BA, 25.05.2003, =D0=B2 05:07, Tom Lane =D0=BF=D0=B8=
=D1=88=D0=B5=D1=82:

> You need to run initdb in the correct locale.  LC_COLLATE and LC_CTYPE
> are both locked down at initdb time, and the latter determines the
> behavior of lower().  You could use pg_controldata to check the
> database's LC_CTYPE, but I'll bet that it's not a Danish locale.
>=20

bert@saphir bert $ su -=20
Password:=20
saphir root # su - postgres
postgres@saphir postgresql $ pg_controldata /var/lib/postgresql/data/ |
grep LC
LC_COLLATE:                           ru_RU.UTF-8
LC_CTYPE:                             ru_RU.UTF-8
postgres@saphir postgresql $ logout
saphir root # logout
bert@saphir bert $ psql template1 postgres
=D0=94=D0=BE=D0=B1=D1=80=D0=BE =D0=BF=D0=BE=D0=B6=D0=B0=D0=BB=D0=BE=D0=B2=
=D0=B0=D1=82=D1=8C =D0=B2 psql 7.3.2 - =D0=98=D0=BD=D1=82=D0=B5=D1=80=D0=B0=
=D0=BA=D1=82=D0=B8=D0=B2=D0=BD=D1=8B=D0=B9 =D0=A2=D0=B5=D1=80=D0=BC=D0=B8=
=D0=BD=D0=B0=D0=BB PostgreSQL.

template1=3D# select lower('=C3=A4=C3=84=C3=B6=C3=96=C3=BC=C3=9C=D0=B0=D0=
=B1=D0=B2=D0=B3=D0=B4=D0=90=D0=91=D0=92=D0=93=D0=94');
              lower=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20
----------------------------------
 =C3=A4=C3=84=C3=B6=C3=96=C3=BC=C3=9C=D0=B0=D0=B1=D0=B2=D0=B3=D0=B4=D0=90=
=D0=91=D0=92=D0=93=D0=94
(1 =D0=B7=D0=B0=D0=BF=D0=B8=D1=81=D1=8C)

template1=3D# \q
bert@saphir bert $=20

What gives?

--=20
Markus Bertheau.
Berlin, Berlin.
Germany.