Received: from mel.alcatel.fr (mel.alcatel.fr [212.208.74.132])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fASGSvm82289
	for <pgsql-admin@postgresql.org>; Wed, 28 Nov 2001 11:28:57 -0500 (EST)
	(envelope-from vincent.gaboriau@answare.fr)
Received: from aifhs2.alcatel.fr (mailhub.alcatel.fr [155.132.180.80])
	by mel.alcatel.fr (ALCANET) with ESMTP id fASGT190005548;
	Wed, 28 Nov 2001 17:29:01 +0100
Received: from frmail30.netfr.alcatel.fr (frmail30.netfr.alcatel.fr
	[155.132.182.163])
	by aifhs2.alcatel.fr (ALCANET/SMTP2) with ESMTP id RAA05754;
	Wed, 28 Nov 2001 17:28:33 +0100 (MET)
Received: from answare.fr ([159.217.208.148])
	by frmail30.netfr.alcatel.fr (Lotus Domino Release 5.0.6a)
	with ESMTP id 2001112817285807:2162 ;
	Wed, 28 Nov 2001 17:28:58 +0100
Message-ID: <3C0510FF.694D34EA@answare.fr>
Date: Wed, 28 Nov 2001 17:29:51 +0100
From: Vincent.Gaboriau@answare.fr
Organization: Answare
X-Mailer: Mozilla 4.75 [fr] (Windows NT 5.0; U)
X-Accept-Language: fr
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: "'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>
Subject: Re: [HACKERS] upper and lower doesn't work with german
References: <20011127085555.A20745-100000@megazone23.bigpanda.com>
	<3C04A23E.BF409D74@answare.fr> <2131.1006960265@sss.pgh.pa.us>
X-MIMETrack: Itemize by SMTP Server on FRMAIL30/FR/ALCATEL(Release 5.0.6a
	|January 17, 2001) at 11/28/2001 17:28:58,
	Serialize by Router on FRMAIL30/FR/ALCATEL(Release 5.0.6a |January 17,
	2001) at 11/28/2001 17:29:01
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id
	fASGWj582413
X-Archive-Number: 200111/149
X-Sequence-Number: 2674



Tom Lane a écrit :

> Vincent.Gaboriau@answare.fr writes:
> >> You might be able to get it by looking through the
> >> <data dir>/global/pg_control file, but it's a binary file so you'll have
> >> to search for it.
>
> > I had found it, but I don't know speak fluent binary language  ;-)
> > Does a way exist to "decompile" it or to get informations on it?
>
> If you can't be troubled to compile up pg_controldata, then you'll
> have to resort to good old od:
>
> $ od -c pg_control
> 0000000 314 201 030 267 255   u 344 277  \0  \0  \0   G 013 355   p 253
> 0000020  \0  \0  \0 004   < 004   ) 006  \0  \0  \0  \0  \0  \0  \0   8
> 0000040  \0  \0  \0  \0   7 026   e 210  \0  \0  \0  \0   7 026   D   h
> 0000060  \0  \0  \0  \0   7 026   e 210  \0  \0  \0  \0  \0  \0  \0  \0
> 0000100  \0  \0  \0  \t  \0 001 357 235  \0 017 017 354   < 004   ) 004
> 0000120  \0  \0      \0  \0 002  \0  \0   C  \0  \0  \0  \0  \0  \0  \0
> 0000140  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
> *
> 0000320  \0  \0  \0  \0  \0  \0  \0  \0   C  \0  \0  \0  \0  \0  \0  \0
> 0000340  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
> *
> 0020000
>
> The LC_COLLATE and LC_CTYPE locale strings should be the last nonzero
> things in the file --- they're both "C" in this example.
>

Thanks to Tom Lane!
But I have This in my pg_control file:

# od -c pg_control
0000000  \0  \0  \0  \0 001  \0  \0  \0  \0  \0  \0  \0  \b  \0  \0  \0
0000020   ¤ 006 004   < 004  \0  \0  \0  \0      \0  \0  \0  \0 002  \0
0000040   ±   Õ   ë  \v  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
0000060  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
*
0020000
#

So no LC_COLLATE and LC_TYPE in the pg_control. But these variables are set in
the user environement!