ERROR: invalid byte sequence for encoding "UTF8": 0x92

From: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date: 2007-03-20 19:34:09
Message-ID: BAY131-F9EB3EF541699B62FB5952B0750@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Hi,

I am using postgres 8.2.3. I have recently converted my database from
sql-ascii to UTF8. I have a portal which calls a perl program to insert the
data into the database.

While inserting, I am getting an error message

DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding
"UTF8": 0x92
[for Statement "INSERT INTO longdescs (bug_id, who, bug_when, thetext,
isprivate)

How can I set the client encoding in perl. Can somebody help me?

Regards
skarthi

_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office
Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ivo Rossacher 2007-03-20 20:03:12 Re: ERROR: invalid byte sequence for encoding "UTF8": 0x92
Previous Message Alexander B. 2007-03-20 18:47:25 Trigger using Tsearch

Browse pgsql-sql by date

  From Date Subject
Next Message Ivo Rossacher 2007-03-20 20:03:12 Re: ERROR: invalid byte sequence for encoding "UTF8": 0x92
Previous Message Bart Degryse 2007-03-20 13:25:01 Re: Select and Count