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

Re: Restoring wrong accents

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 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-23 20:30:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
=?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: Laurent CARONDate: 2007-11-24 23:18:32
Subject: Migrating from 32 to 64 bit
Previous:From: José Roberto Motta GarciaDate: 2007-11-23 19:15:37
Subject: Restoring wrong accents

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