| 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: | Whole Thread | Raw Message | 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
| 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 |