Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D4D6F2E003B for ; Fri, 23 Nov 2007 16:31:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 99693-04 for ; Fri, 23 Nov 2007 16:31:07 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 4EFC22E003A for ; Fri, 23 Nov 2007 16:31:10 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lANKUTAT018371; Fri, 23 Nov 2007 15:30:29 -0500 (EST) To: =?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= cc: pgsql-admin@postgresql.org Subject: Re: Restoring wrong accents In-reply-to: <474726D9.4020907@cptec.inpe.br> References: <474726D9.4020907@cptec.inpe.br> Comments: In-reply-to =?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= message dated "Fri, 23 Nov 2007 17:15:37 -0200" Date: Fri, 23 Nov 2007 15:30:29 -0500 Message-ID: <18370.1195849829@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/206 X-Sequence-Number: 27449 =?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= 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