From: Ben K. <bkim@coe.tamu.edu>
To: pgsql-admin@postgresql.org
Subject: encoding question
Date: Mon, 20 Mar 2006 16:56:57 -0600 (CST)
Message-ID: <Pine.GSO.4.64.0603201643250.21796@coe.tamu.edu> (raw)
Hi,
My main server is on Solaris (LANG=C), postgresql 8.1.0, with encoding
SQL_ASCII.
I'm trying to set up a backup server on linux (LANG=en_US.UTF-8), with
encoding UTF8.
I thought UTF8 was safe if all I have is ascii, since there was a relevant
discussion in this list a short while ago, but I'm getting this error, for
a few records (out of tens of thousands in that database).
===============
ERROR: invalid UTF-8 byte sequence detected near byte 0x85
CONTEXT: COPY tblcoursesinfo, line 30, column title: "Seminar in<85>
..."
===============
The dump was created by 8.1.0's pg_dump with no options.
That line in the dump has the following contents.
Text:
n<85> Knowledg
Binary:
02e2100: 6e85 2020 2020 2020 2020 2020 2020 2020 n.
02e2110: 2020 2020 2020 2020 2020 2020 2020 2020
02e2120: 2020 2020 2020 2020 2020 2020 2020 2020
02e2130: 2020 2020 2020 2020 2020 2020 2020 2020
02e2140: 2020 2020 2020 2020 2020 2020 2020 2020
02e2150: 2020 2020 2020 2020 2020 2020 2020 2020
02e2160: 2020 2020 2020 2020 2020 2020 2020 2020
02e2170: 2020 2020 2020 2009 4b6e 6f77 6c65 6467 .Knowledg
Where could this be coming from? Would appreciate help.
Regards,
Ben K.
Developer
http://benix.tamu.edu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bkim@coe.tamu.edu
Subject: Re: encoding question
In-Reply-To: <Pine.GSO.4.64.0603201643250.21796@coe.tamu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox