pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: José Roberto Motta Garcia <garcia@cptec.inpe.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: Restoring wrong accents
Date: Mon, 26 Nov 2007 16:58:23 -0200
Message-ID: <474B174F.8050503@cptec.inpe.br> (raw)
In-Reply-To: <18370.1195849829@sss.pgh.pa.us>
References: <474726D9.4020907@cptec.inpe.br>
	<18370.1195849829@sss.pgh.pa.us>

You where right. It's ok now, it was the old one "If you want it to be
done correctly do it yourself".

Tks a lot.

Jose Roberto M. Garcia, MSc
Analista de Sistemas - Grupo Banco de Dados
Fone: (12) 3186-8405 
-- 
A luta contra o aquecimento global depende de cada um de nós, faça sua parte, economize recursos naturais.
-- 
http://www.cptec.inpe.br
http://www.inpe.br 



Tom Lane wrote:
> =?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <garcia@cptec.inpe.br> writes:
>   
>> We're having problems restoring the characters correctly here. We have a
>> 8.1 PG on Suse created with LATIN1 and pt_BR. As a latin language we use
>> several special chars like á, ã, ç, í, etc.
>>     
>
>   
>> We made a dump -a and after restoring it to an also 8.1 PG on Suse
>> created with LATIN1 and pt_BR we noticed that a lot of these special
>> chars weren't restored correctly. We couldn't notice any rule for that,
>>     
>
> It seems highly unlikely that you actually had the same encoding in both
> cases, since if that were the case no conversion would have occurred.
> Please double-check the two database encodings.  Also, what encoding is
> called out in the first few lines of the dump file?
>
> 			regards, tom lane
>   



view thread (3+ messages)

Message-ID: <474B174F.8050503@cptec.inpe.br>
Permalink:  ../474B174F.8050503@cptec.inpe.br/
Also on:    postgresql.org/message-id/474B174F.8050503@cptec.inpe.br

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: garcia@cptec.inpe.br
  Subject: Re: Restoring wrong accents
  In-Reply-To: <474B174F.8050503@cptec.inpe.br>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox