| 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: | 18370.1195849829@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurent CARON | 2007-11-24 23:18:32 | Migrating from 32 to 64 bit |
| Previous Message | José Roberto Motta Garcia | 2007-11-23 19:15:37 | Restoring wrong accents |