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)
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 |