Re: invalid byte sequence for encoding "UTF8":

>
> On Jan 8, 2009, at 2:34 PM, kulmacet101@kulmacet.com wrote:
>
>> 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
>
>
>
>
> Kulmacet,
>
> is your source data also in UTF-8 ?
>
> Ries
>
>
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

I'm not sure how to determine if the source data is UTF-8. This data is
coming from a post to a form.