Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 3DC0D64FD06
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed,  3 Sep 2008 14:58:39 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 85382-03 for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed,  3 Sep 2008 14:58:34 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.237])
	by postgresql.org (Postfix) with ESMTP id 289A964FCF3
	for <pgsql-admin@postgresql.org>; Wed,  3 Sep 2008 14:58:34 -0300 (ADT)
Received: by rv-out-0506.google.com with SMTP id b25so4013531rvf.43
	for <pgsql-admin@postgresql.org>; Wed, 03 Sep 2008 10:58:33 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=ze9BbhlZFJM5dRpyPHnQoPFetxp4pc2xDLZHXGU4zsk=;
	b=kvIOf3zuuWCSrPFFTd1N2cnyRVyu4qnySPDRIKMqqto/L6TaT6N1tWgmEjr2BfWHnQ
	ei9wfTGT42NaiSMCGTW4SxDk3nL82Gmsn19l9y4Fx37sav/EfpeFFiHGOmfTnNr8JylE
	ONL4zjMr7tsE+7wDC6UQRbKYpEQAdyfyBXpaU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:references;
	b=mWbU5bDF3E0K9akOKjGiZUcsQpgEyqDZk0K31cObMlz3CVNARGsQ0FMfJRqV4DVyeU
	6bKzZ5qIJ2PRuBy/G0PTXAPtL3EnEoQksUCwtAOKhr3DopTzTKan1fpaO5cyeSLiQhD9
	nBWSpNkbmPgT7Ea79MCYrixWwFkl7AGdq4ogc=
Received: by 10.141.206.13 with SMTP id i13mr5110515rvq.100.1220464713038;
	Wed, 03 Sep 2008 10:58:33 -0700 (PDT)
Received: by 10.141.175.19 with HTTP; Wed, 3 Sep 2008 10:58:32 -0700 (PDT)
Message-ID: <d65067e10809031058g6a4a145emaef820a498fb771b@mail.gmail.com>
Date: Wed, 3 Sep 2008 10:58:32 -0700
From: "Jeremy Tunnell" <jeremy.tunnell@gmail.com>
To: "Anibal David Acosta" <aa@personal.net.py>
Subject: Re: Database encoding
Cc: pgsql-admin@postgresql.org
In-Reply-To: <000001c90dca$a5e653a0$f1b2fae0$@net.py>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_20921_31254077.1220464713026"
References: <46F5921DF52F6E40860287B30CADADC7A67ACE@EROS.nexus-ag.com>
	<000001c90dca$a5e653a0$f1b2fae0$@net.py>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200809/12
X-Sequence-Number: 30105

------=_Part_20921_31254077.1220464713026
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

The setting is in a file called i18n, but I can't recall where it's located.

On Wed, Sep 3, 2008 at 6:40 AM, Anibal David Acosta <aa@personal.net.py>wrote:

>   Hello, I have a postgresql installed with encoding "WIN1252".
>
>
>
> But I need to create a DB with LATIN1 encoding, when I try I got the error:
> "Encoding Latin1 does not match server's locale Spanish_Spain.1252. The
> servers's LC_CTYPE setting require encoding WIN1252
>
>
>
>
>
> Is possible to change the server encoding to LATIN1?
>
>
>
>
>
> Thanks for your help!
>
>
>
>
>

------=_Part_20921_31254077.1220464713026
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">The setting is in a file called i18n, but I can&#39;t recall where it&#39;s located.<br><br><div class="gmail_quote">On Wed, Sep 3, 2008 at 6:40 AM, Anibal David Acosta <span dir="ltr">&lt;<a href="mailto:aa@personal.net.py">aa@personal.net.py</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">








<div link="blue" vlink="purple" lang="ES-PY">

<div>

<div>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Hello, I have a postgresql installed with encoding "WIN1252".</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">&nbsp;</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">But I need to create a DB with LATIN1 encoding, when I try I got
the error: "Encoding Latin1 does not match server's locale Spanish_Spain.1252.
The servers's LC_CTYPE setting require encoding WIN1252</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">&nbsp;</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">&nbsp;</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Is possible to change the server encoding to LATIN1?</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">&nbsp;</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">&nbsp;</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Thanks for your help!</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">&nbsp;</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">&nbsp;</span></p>

</div>

</div>

</div>


</blockquote></div><br></div>

------=_Part_20921_31254077.1220464713026--