|
|
Subject: Finding bad bye in "invalid byte sequence" error
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 12/14/2007 12:07:02 PM
robert <robertlazarski@gmail.com> writes:
> I'm getting this error:
> psql -h localhost atdev < fuk2.sql
> ERROR: invalid byte sequence for encoding "UTF8": 0xe1204f
> 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".
Well, that isn't UTF8, and it isn't plain ASCII either. I'm betting
it's a single-byte encoding, probably one of the ISO-8859 series.
Have you looked at the data to see what *you* think the character is?
(Feed the script to psql with -f, not <, to get a line number for
the error.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
|