OK, I'm mailing the list the results of my problem so future people can find it.
The error was
ERROR: invalid byte sequence for encoding "UTF8": 0xa2
with many different types of 0x... lines.
The problem was indeed a bug, but one that sat between the keyboard
and screen (that is, me), not with
"Mikel Lindsaar" <[EMAIL PROTECTED]> writes:
> But I am hitting a problem. When I try to import the result with COPY
> I am getting:
> ERROR: invalid byte sequence for encoding "UTF8": 0xa2
> And gives me a line reference.
> I then grabbed that line out of the file, unpacked each byte into a
> de
> Anyone got any ideas how I can hunt down what is in this row, visually
> looking at it hasn't helped?
As a followup, I am getting this same sort of error at various points
on the file.
So I tried taking the line, and cleaning it with Iconv and turning it
into an ASCII sequence and inserting it
On Tue, 30 Jun 1998, Jeffrey Napolitano wrote:
> > > I'm new to Postgres(or otherwise I probably wouldn't be sending this),
> > > and I've gone through the HTML docs online, and looked at the man pages,
> > > but I can't find anything about importing ODBC compliant data into
> > > postgres ... I
> > I'm new to Postgres(or otherwise I probably wouldn't be sending this),
> > and I've gone through the HTML docs online, and looked at the man pages,
> > but I can't find anything about importing ODBC compliant data into
> > postgres ... I assumed this was possible ... am I wrong? If not, could
Mike Edwards wrote:
> On Tue, 23 Jun 1998, Jeffrey Napolitano wrote:
>
> > I'm new to Postgres(or otherwise I probably wouldn't be sending this),
> > and I've gone through the HTML docs online, and looked at the man pages,
> > but I can't find anything about importing ODBC compliant data into
>
Jeffrey Napolitano wrote:
> I'm new to Postgres(or otherwise I probably wouldn't be sending this),
> and I've gone through the HTML docs online, and looked at the man pages,
> but I can't find anything about importing ODBC compliant data into
> postgres ... I assumed this was possible ... am I
On Tue, 23 Jun 1998, Jeffrey Napolitano wrote:
> I'm new to Postgres(or otherwise I probably wouldn't be sending this),
> and I've gone through the HTML docs online, and looked at the man pages,
> but I can't find anything about importing ODBC compliant data into
> postgres ... I assumed this was
