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

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

From: Ivo Rossacher <rossacher(at)bluewin(dot)ch>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date: 2007-03-20 20:03:12
Message-ID: 200703202103.12280.rossacher@bluewin.ch (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
Am Dienstag, 20. März 2007 20:34 schrieb Karthikeyan Sundaram:
> 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

After the connection is done send set client_encoding  to '<Encoding Perl is 
using>' to the server. The server then will convert the strings back and 
forward for you.
Se manual chapter 21.2 Character Set Support for more details.

Best regards
Ivo
>
> _________________________________________________________________
> Get a FREE Web site, company branded e-mail and more from Microsoft Office
> Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate

In response to

pgsql-admin by date

Next:From: Claus GuttesenDate: 2007-03-20 20:06:25
Subject: Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92
Previous:From: Karthikeyan SundaramDate: 2007-03-20 19:34:09
Subject: ERROR: invalid byte sequence for encoding "UTF8": 0x92

pgsql-sql by date

Next:From: Claus GuttesenDate: 2007-03-20 20:06:25
Subject: Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92
Previous:From: Karthikeyan SundaramDate: 2007-03-20 19:34:09
Subject: ERROR: invalid byte sequence for encoding "UTF8": 0x92

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