On 12/13/07, robert <[EMAIL PROTECTED]> wrote: > 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".
The cleanest way to fix this is to figure out what encoding the data in your SQL script is (since I am assuming parts of it were dumped directly out of MSSQL) and set client_encoding to that. Your data is almost certainly not straight 7-bit ASCII. -Doug ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
