On Jan 8, 2009, at 2:34 PM, kulmacet101(at)kulmacet(dot)com wrote:
> 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
> STATEMENT: UPDATE preferences SET property = $1,preference_value =
> $2,comment = $3,topic = $4 WHERE app_hash =
> 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,
is your source data also in UTF-8 ?
In response to
pgsql-novice by date
|Next:||From: kulmacet101||Date: 2009-01-08 20:08:25|
|Subject: Re: invalid byte sequence for encoding "UTF8":|
|Previous:||From: kulmacet101||Date: 2009-01-08 19:34:49|
|Subject: invalid byte sequence for encoding "UTF8":|