| From: | Maurício Cruz <cruz(at)sygecom(dot)com(dot)br> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | win1252 to UTF8 |
| Date: | 2011-12-21 21:08:15 |
| Message-ID: | 4EF24ABF.8010001@sygecom.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig James | 2011-12-22 00:33:37 | Re: Can't Insert from Staging Table to Production Table |
| Previous Message | Elliot Voris | 2011-12-21 20:34:27 | Can't Insert from Staging Table to Production Table |