Finding bad bye in "invalid byte sequence" error

From: robert <robertlazarski(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Finding bad bye in "invalid byte sequence" error
Date: 2007-12-13 18:38:36
Message-ID: 10b06817-e33d-4109-a7f9-22796af0e012@b1g2000pra.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm trying to hack my inserts script from mssql to work with postgres
8.1.9 - I can upgrade if need be. 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".

I tried:

/var/lib/pgsql> recode ascii..utf8 fuk2.sql
recode: fuk2.sql failed: Invalid input in step `ANSI_X3.4-1968..UTF-8'

And also dos2unix , but nothing is working. 0xe1204f looks like a hex
address, and I'm trying hexdump to find what its complaining about,
but that's not helping either. Any ideas?

Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message peter pilsl 2007-12-13 18:42:00 extend "group by" to include "empty relations" ?
Previous Message Tom Lane 2007-12-13 18:19:17 Re: Hash join in 8.3