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@xxxxxxxxxxxxx> 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 > ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
