----- Original Message -----
From: "Ashish Karalkar" <ashish.karalkar@xxxxxxxxxxxxxxxxx>
To: "Albe Laurenz" <all@xxxxxxxxxxxxxxxxx>
Sent: Monday, September 03, 2007 4:09 PM
Subject: Re: invalid byte sequence for encoding "UTF8": 0xff
----- Original Message -----
From: "Albe Laurenz" <all@xxxxxxxxxxxxxxxxx>
To: "Ashish Karalkar *EXTERN*" <ashish.karalkar@xxxxxxxxxxxxxxxxx>;
<pgsql-general@xxxxxxxxxxxxxx>
Sent: Monday, September 03, 2007 2:12 PM
Subject: Re: invalid byte sequence for encoding "UTF8": 0xff
Ashish Karalkar wrote:
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 byte sequence for encoding "UTF8": 0xff
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".
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)
Can you tell us the following:
Please find my answer below
- What is the client operating system (where you run psql and
PgAdmin III)?
Its Windows XP - PgAdmin III
RHEL 3.4.3-9.EL4-psql (Server Machine)
- What is the value of the environment variable PGCLIENTENCODING
set to on the client?
PGCLIENTENCODING is not set and as per documantation I think by default it
takes value of database i.e. UTF8
- What does the SQL command "show client_encoding;" return
when you issue it in
a) PgAdmin III
UNICODE
b) psql
UTF8
- Please create a file that contains only the first line
of QSWEB_100_4_Default_Data.sql (I call it "l" in the following
commands), run the following two (Linux) commands on it:
a) od -t c l
b) od -t x1 l
and show us the output of both commands.
[root@localhost qsweb]# od -t c test.sql
0000000 \ s e t O N _ E R R O R _ S T
0000020 O P
0000022
[root@localhost qsweb]# od -t x1 test.sql
0000000 5c 73 65 74 20 4f 4e 5f 45 52 52 4f 52 5f 53 54
0000020 4f 50
0000022
[root@localhost qsweb]#
Thanks Albe for your replay.
here is the data you wanted
Yours,
Laurenz Albe
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
