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

Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92

From: "Claus Guttesen" <kometen(at)gmail(dot)com>
To: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date: 2007-03-20 20:06:25
Message-ID: b41c75520703201306w2a1e08a5n41c86395f778d25b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
>    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

In response to

Responses

pgsql-admin by date

Next:From: Bruce MomjianDate: 2007-03-21 00:01:33
Subject: Re: WAL based backup/recovery clarifications
Previous:From: Ivo RossacherDate: 2007-03-20 20:03:12
Subject: Re: ERROR: invalid byte sequence for encoding "UTF8": 0x92

pgsql-sql by date

Next:From: JudithDate: 2007-03-20 23:54:47
Subject: Substitute
Previous:From: Ivo RossacherDate: 2007-03-20 20:03:12
Subject: Re: ERROR: invalid byte sequence for encoding "UTF8": 0x92

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