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
>