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

invalid byte sequence for encoding "UTF8":

From: kulmacet101(at)kulmacet(dot)com
To: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: invalid byte sequence for encoding "UTF8":
Date: 2009-01-08 19:34:49
Message-ID: 1da9e171669633bd8fd66b0ed1428cfe.squirrel@webmail.kulmacet.com (view raw or flat)
Thread:
Lists: pgsql-novice
All,

I have a new postgresql<8.3.4> build on linux<CentOS5> with PHP talking to
this database. If I try and update or insert on data that has special
characters I get this error:

ERROR:  invalid byte sequence for encoding "UTF8": 0xa9
HINT:  This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
STATEMENT:  UPDATE preferences SET property = $1,preference_value =
$2,comment = $3,topic = $4 WHERE app_hash =
'50e2606ed950e8021d64349b49f4ee48'

I have read some articles about client_encoding but I do not know how to
get around this error.

Any help or support appreciated.
Thanks in advance,
Kulmacet


Responses

pgsql-novice by date

Next:From: ries van TwiskDate: 2009-01-08 19:41:49
Subject: Re: invalid byte sequence for encoding "UTF8":
Previous:From: Tom LaneDate: 2009-01-08 18:46:08
Subject: Re: How to release a transaction lock on a table

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