Group: pgsql.general


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