Skip site navigation (1) Skip section navigation (2)

Re: Restoring wrong accents

From: José Roberto Motta Garcia <garcia(at)cptec(dot)inpe(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restoring wrong accents
Date: 2007-11-26 18:58:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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.

Tom Lane wrote:
> =?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <garcia(at)cptec(dot)inpe(dot)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

In response to

pgsql-admin by date

Next:From: Jose CalderonDate: 2007-11-26 20:16:55
Subject: database cluster missing
Previous:From: Medi MontaseriDate: 2007-11-26 18:52:52
Subject: Re: Migrating from 32 to 64 bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group