From: | Bob Hunter <catdogbeloved(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | encoding problem at restore |
Date: | 2007-02-17 11:12:44 |
Message-ID: | 6338.59322.qm@web31301.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have just updated to postgres8.1 and have the
following problem. The first line of the "PostgreSQL
database dump"
says:
SET client_encoding = 'SQL_ASCII';
which is correct. However, the restore says:
ERROR: invalid byte sequence for encoding "UTF8":
0xe02031
HINT: This error can also happen if the byte sequence
does not match the encoding expected by the server,
which is controlled by "client_encoding".
CONTEXT: COPY <tablename>, line 1270
There are two problems. The first is, why UTF8 at all,
given that the dump specifies SQL_ASCII? The second
is, that at line 1270 there are (unsurprisingly) only
ASCII characters, so why is psql complaining at all?
Thank you.
P.S. I am not subscribed, so please Cc the answers to me.
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited
From | Date | Subject | |
---|---|---|---|
Next Message | Mikko Partio | 2007-02-17 12:39:15 | Re: Cast record as text |
Previous Message | Tatsuo Ishii | 2007-02-17 11:08:33 | Re: [GENERAL] [ANNOUNCE] Advisory on possibly insecure security definer functions |