invalid byte sequence for encoding "UTF8": 0xff

From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: invalid byte sequence for encoding "UTF8": 0xff
Date: 2007-09-03 08:06:58
Message-ID: 011d01c7ee01$7a0fc3e0$170211ac@LIONKING.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I have a data script which runs fine from PgAdmin SQL Editor,but when I run this from command prompt I get following error:

test=# \i /usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql

psql:/usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql:1: ERROR: invalid byt
e sequence for encoding "UTF8": 0xff
HINT: This error can also happen if the byte sequence does not match the encodi
ng expected by the server, which is controlled by "client_encoding".

can anybody suggest me what is going wrong.
database encoding :UTF8

PostgreSQL details:

version
-------------------------------------------------------------------------------------------------------
PostgreSQL 8.2.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3 20041212 (Red Hat 3.4.3-9.EL4)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-09-03 08:15:56 Re: invalid byte sequence for encoding "UTF8": 0xff
Previous Message Andrej Ricnik-Bay 2007-09-03 07:59:02 Re: Data Warehousing