Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92 - Mailing list pgsql-admin

From Claus Guttesen
Subject Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date
Msg-id b41c75520703201306w2a1e08a5n41c86395f778d25b@mail.gmail.com
Whole thread Raw
In response to ERROR: invalid byte sequence for encoding "UTF8": 0x92  ("Karthikeyan Sundaram" <skarthi98@hotmail.com>)
Responses Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
>    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)

Try to modify client_encoding in postgresql.conf to utf8 and restart your db.

regards
Claus

pgsql-admin by date:

Previous
From: "Karthikeyan Sundaram"
Date:
Subject: ERROR: invalid byte sequence for encoding "UTF8": 0x92
Next
From: Ivo Rossacher
Date:
Subject: Re: ERROR: invalid byte sequence for encoding "UTF8": 0x92