Re: invalid byte sequence for encoding "UTF8":

On Jan 8, 2009, at 3:08 PM, kulmacet101@kulmacet.com wrote:

>>
>> 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.



Your website might not be in UTF-8 in that case.

Ries