=?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 CARON||Date: 2007-11-24 23:18:32|
|Subject: Migrating from 32 to 64 bit|
|Previous:||From: José Roberto Motta Garcia||Date: 2007-11-23 19:15:37|
|Subject: Restoring wrong accents|