Restoring wrong accents - Mailing list pgsql-admin

From José Roberto Motta Garcia
Subject Restoring wrong accents
Date
Msg-id 474726D9.4020907@cptec.inpe.br
Whole thread Raw
Responses Re: Restoring wrong accents  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi all,

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,
but some chars were restored correctly and others not.

Any ideas to what's happening?

Tks.

Jose Roberto M. Garcia, MSc
Voice: (12) 3186-8405
--
http://www.cptec.inpe.br
http://www.inpe.br


pgsql-admin by date:

Previous
From: "LEROUX Ludovic"
Date:
Subject: problem with drop database or dropdb.exe on windows with postgresql 8.1
Next
From: Tom Lane
Date:
Subject: Re: Restoring wrong accents