Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E47452E003B for ; Fri, 23 Nov 2007 15:16:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 51588-06 for ; Fri, 23 Nov 2007 15:15:54 -0400 (AST) Received: from cptec.inpe.br (guapira.cptec.inpe.br [150.163.140.191]) by postgresql.org (Postfix) with ESMTP id 82EA82E0046 for ; Fri, 23 Nov 2007 15:15:54 -0400 (AST) Received: from [150.163.140.242] (manoia.cptec.inpe.br [150.163.140.242]) by cptec.inpe.br (8.12.10/8.12.4) with ESMTP id lANJPBVb025392 for ; Fri, 23 Nov 2007 16:25:11 -0300 (EST) Message-ID: <474726D9.4020907@cptec.inpe.br> Date: Fri, 23 Nov 2007 17:15:37 -0200 From: =?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= User-Agent: Thunderbird 1.5 (X11/20060317) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Restoring wrong accents Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.514 tagged_above=0 required=5 tests=AWL=0.513, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200711/205 X-Sequence-Number: 27448 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