Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 8369014E23D6 for ; Wed, 21 Dec 2011 16:08:39 -0400 (AST) Received: from smtp147.uni5.net ([189.38.92.147]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RdSSr-0004hr-IT for pgsql-admin@postgresql.org; Wed, 21 Dec 2011 20:08:39 +0000 Received: from smtp-gw-01.uni5.net (smtp-gw-01 [127.0.0.1]) by smtp147.uni5.net (Postfix) with ESMTP id B53AE36B22 for ; Wed, 21 Dec 2011 18:08:21 -0200 (BRST) Received: from [192.168.0.192] (unknown [201.47.216.46]) by smtp-gw-01.uni5.net (Postfix) with ESMTPSA id A9E569A834C5B for ; Wed, 21 Dec 2011 18:08:21 -0200 (BRST) Message-ID: <4EF24ABF.8010001@sygecom.com.br> Date: Wed, 21 Dec 2011 18:08:15 -0300 From: =?ISO-8859-1?Q?Maur=EDcio_Cruz?= User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: win1252 to UTF8 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201112/118 X-Sequence-Number: 38876 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=20 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=E7=E3= o=20 "WIN1252" n=E3o tem equivalente em "UTF8" ( translation: pg_dump: Error message from server: ERRO: caracter=20 0x8d of codification "WIN1252" don't have equivalent in "UTF8" ) also I tryed to run pg_dump converting to codification LATIN1 but=20 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=20 convert into UTF8 ... but I fail! is there a good soul to help me out in this matter ?? Thanks a lot every one.