Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 25 Jan 2008 15:53:35 -0500
- Message-id: <479A4C4F(dot)2060805(at)coopfed(dot)org>
Ok, that did it. Thank you for the help. Tomasz Ostrowski wrote:
On Wed, 23 Jan 2008, Tom Hart wrote: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.pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for encoding "UTF8": 0xc52fTry editing your dump-file and change the line which reads "SET client_encoding = 'SQL_ASCII';" to "SET client_encoding = 'LATIN1';"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)
- References:
- ascii to utf-8
- From: Tom Hart
- Re: ascii to utf-8
- From: Tommy Gildseth
- Re: ascii to utf-8
- From: Tom Hart
- Re: ascii to utf-8
- From: Tomasz Ostrowski
- ascii to utf-8
- Prev by Date: Re: shouldn't all tables have Object Descriptions?
- Next by Date: Re: match accented chars with ASCII-normalised version
- Previous by thread: Re: ascii to utf-8
- Next by thread: Re: ascii to utf-8
- Indexes: