pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestoring wrong accents
3+ messages / 2 participants
[nested] [flat]
* Restoring wrong accents
@ 2007-11-23 19:15 José Roberto Motta Garcia <garcia@cptec.inpe.br>
0 siblings, 1 reply; 3+ messages in thread
From: José Roberto Motta Garcia @ 2007-11-23 19:15 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Restoring wrong accents
@ 2007-11-23 20:30 Tom Lane <tgl@sss.pgh.pa.us>
parent: José Roberto Motta Garcia <garcia@cptec.inpe.br>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2007-11-23 20:30 UTC (permalink / raw)
To: José Roberto Motta Garcia <garcia@cptec.inpe.br>; +Cc: pgsql-admin
=?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <garcia@cptec.inpe.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Restoring wrong accents
@ 2007-11-26 18:58 José Roberto Motta Garcia <garcia@cptec.inpe.br>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: José Roberto Motta Garcia @ 2007-11-26 18:58 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
You where right. It's ok now, it was the old one "If you want it to be
done correctly do it yourself".
Tks a lot.
Jose Roberto M. Garcia, MSc
Analista de Sistemas - Grupo Banco de Dados
Fone: (12) 3186-8405
--
A luta contra o aquecimento global depende de cada um de nós, faça sua parte, economize recursos naturais.
--
http://www.cptec.inpe.br
http://www.inpe.br
Tom Lane wrote:
> =?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <garcia@cptec.inpe.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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-11-26 18:58 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-23 19:15 Restoring wrong accents José Roberto Motta Garcia <garcia@cptec.inpe.br>
2007-11-23 20:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-11-26 18:58 ` José Roberto Motta Garcia <garcia@cptec.inpe.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox