Thread: Restoring wrong accents
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
=?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
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 >