From aa@personal.net.py Wed Sep 3 14:46:04 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E24D664FF57 for ; Wed, 3 Sep 2008 11:46:04 -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 96161-04 for ; Wed, 3 Sep 2008 11:45:56 -0300 (ADT) X-Greylist: delayed 01:00:59.724665 by SQLgrey-1.7.6 Received: from mail.devshock.com (mail.guaijole.com [201.217.17.101]) by postgresql.org (Postfix) with SMTP id CB1E864FCEB for ; Wed, 3 Sep 2008 11:45:55 -0300 (ADT) Received: from nbanibal ([200.85.62.34]) by mail.devshock.com with hMailServer ; Wed, 3 Sep 2008 09:45:02 -0400 From: "Anibal David Acosta" To: References: <46F5921DF52F6E40860287B30CADADC7A67ACE@EROS.nexus-ag.com> In-Reply-To: <46F5921DF52F6E40860287B30CADADC7A67ACE@EROS.nexus-ag.com> Subject: Database encoding Date: Wed, 3 Sep 2008 09:40:36 -0400 Message-ID: <000001c90dca$a5e653a0$f1b2fae0$@net.py> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C90DA9.1ED4B3A0" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AckNxQSh0PSTJfV/TLuFu0+dmqVvBwABRGZw Content-Language: es-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/7 X-Sequence-Number: 30100 Este es un mensaje con varias partes en formato MIME. ------=_NextPart_000_0001_01C90DA9.1ED4B3A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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! ------=_NextPart_000_0001_01C90DA9.1ED4B3A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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!

------=_NextPart_000_0001_01C90DA9.1ED4B3A0-- From jeremy.tunnell@gmail.com Wed Sep 3 17:58:39 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3DC0D64FD06 for ; 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 ; 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 ; Wed, 3 Sep 2008 14:58:34 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so4013531rvf.43 for ; 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: Date: Wed, 3 Sep 2008 10:58:32 -0700 From: "Jeremy Tunnell" To: "Anibal David Acosta" 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 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

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-- From valgog@gmail.com Thu Sep 4 08:01:50 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D394F64FCF3 for ; Thu, 4 Sep 2008 05:01:50 -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 68710-02 for ; Thu, 4 Sep 2008 05:01:49 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id E4CCD64FCEB for ; Thu, 4 Sep 2008 05:01:15 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id m8481CoK025722 for ; Thu, 4 Sep 2008 05:01:12 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id m847Z1DM094153 for pgsql-admin@postgresql.org; Thu, 4 Sep 2008 04:35:01 -0300 (ADT) (envelope-from news) From: valgog X-Newsgroups: pgsql.admin Subject: Re: Database encoding Date: Thu, 4 Sep 2008 00:35:02 -0700 (PDT) Organization: http://groups.google.com Lines: 24 Message-ID: <0302d94a-7a8e-46cc-bc47-c6b02623c38c@r15g2000prd.googlegroups.com> References: <46F5921DF52F6E40860287B30CADADC7A67ACE@EROS.nexus-ag.com> <000001c90dca$a5e653a0$f1b2fae0$@net.py> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Complaints-To: groups-abuse@google.com Complaints-To: groups-abuse@google.com Injection-Info: r15g2000prd.googlegroups.com; posting-host=85.178.243.78; posting-account=zGCcogoAAAArwo4vzM49iZKKucd6_BKu User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.0.1) Gecko/2008070206 Firefox/3.0.1,gzip(gfe),gzip(gfe) To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200809/15 X-Sequence-Number: 30108 On Sep 3, 3:40=A0pm, a...@personal.net.py ("Anibal David Acosta") 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 erro= r: > "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! You should use the same encoding for your DB instance as you used when creating a DB with initdb. Usually it makes sense to always use UTF8 as your encoding... in case you will need some non-LATIN1 characters... you can check which encoding was used when creating a DB with show lc_ctype... Regards, -- Valentine P.S.: there are many posts related to that issue. You can look up a BUG mailing list for collate and encoding.