agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Michael Fuhr <mike@fuhr.org>
To: Claus Guttesen <kometen@gmail.com>
Cc: Karthikeyan Sundaram <skarthi98@hotmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92
Date: Tue, 20 Mar 2007 21:32:44 -0600
Message-ID: <20070321033244.GA39959@winnie.fuhr.org> (raw)
In-Reply-To: <b41c75520703201306w2a1e08a5n41c86395f778d25b@mail.gmail.com>
References: <BAY131-F9EB3EF541699B62FB5952B0750@phx.gbl>
<b41c75520703201306w2a1e08a5n41c86395f778d25b@mail.gmail.com>
On Tue, Mar 20, 2007 at 09:06:25PM +0100, Claus Guttesen wrote:
> >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.
The data is apparently not UTF-8 so client_encoding needs to be set
to something else. 0x92 is a hint that the encoding might be
Windows-1252 or Windows-1250 since that byte represents the right
single quotation mark in those encodings; that's a common character
in data that originated in Windows. Also, client_encoding can be set
by the client without having to restart the backend.
--
Michael Fuhr
view thread (7+ messages) latest in thread
Message-ID: <20070321033244.GA39959@winnie.fuhr.org>
Permalink: ../20070321033244.GA39959@winnie.fuhr.org/
Also on: postgresql.org/message-id/20070321033244.GA39959@winnie.fuhr.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, kometen@gmail.com, skarthi98@hotmail.com, pgsql-admin@postgresql.org
Subject: Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92
In-Reply-To: <20070321033244.GA39959@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox