From: Maurício Cruz <cruz@sygecom.com.br>
To: pgsql-admin@postgresql.org
Subject: win1252 to UTF8
Date: Wed, 21 Dec 2011 18:08:15 -0300
Message-ID: <4EF24ABF.8010001@sygecom.com.br> (raw)
Hi all,
I need to convert my database from codification WIN1252 to UTF8,
I've try to use pg_dump -U postgres -h 192.168.0.192 -E UTF8 -v -F p -f
bkp.sql database
but I have to following erro:
pg_dump: SQL command failed
pg_dump: Error message from server: ERRO: caracter 0x8d da codificação
"WIN1252" não tem equivalente em "UTF8"
( translation: pg_dump: Error message from server: ERRO: caracter
0x8d of codification "WIN1252" don't have equivalent in "UTF8" )
also I tryed to run pg_dump converting to codification LATIN1 but
then I have the follow erro:
pg_dump: invalid client encoding "LATIN1" specified
may be I could bring a dump file in LATIN1 and then user iconve to
convert into UTF8 ... but I fail!
is there a good soul to help me out in this matter ??
Thanks a lot every one.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cruz@sygecom.com.br
Subject: Re: win1252 to UTF8
In-Reply-To: <4EF24ABF.8010001@sygecom.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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