Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group