Re: ascii to utf-8

From: Tom Hart <tomhart(at)coopfed(dot)org>
To: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>
Cc: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>, Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: ascii to utf-8
Date: 2008-01-25 20:53:35
Message-ID: 479A4C4F.2060805@coopfed.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok, that did it. Thank you for the help.

Tomasz Ostrowski wrote:
> On Wed, 23 Jan 2008, Tom Hart wrote:
>
>
>>>> pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence
>>>> for encoding "UTF8": 0xc52f
>>>>
>>> Try editing your dump-file and change the line which reads "SET
>>> client_encoding = 'SQL_ASCII';" to "SET client_encoding = 'LATIN1';"
>>>
>> I tried making the changes you specified with notepad, wordpad, gVim, vim
>> and emacs and in each case pgAdmin (and pg_restore) complain about the dump
>> header being corrupted.
>>
>
> Try an "-E LATIN1" option in pg_dump. Do you at least know what is
> the encoding of data in the database?
>
> Regards
> Tometzky
>

--
Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
Syracuse, NY 13210
(315) 471-1116 ext. 202
(315) 476-0567 (fax)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-01-26 02:46:24 Re: match accented chars with ASCII-normalised version
Previous Message Raymond O'Donnell 2008-01-25 20:48:13 Re: shouldn't all tables have Object Descriptions?