Re: UTF8 encoding problem

From: Giorgio Valoti <giorgio_v(at)mac(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: UTF8 encoding problem
Date: 2008-06-18 06:25:07
Message-ID: BD241A58-9AA3-4255-AE32-43EA665EAB0B@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 18/giu/08, at 03:04, Michael Fuhr wrote:

> On Tue, Jun 17, 2008 at 10:48:34PM +0100, Garry Saddington wrote:
>> I am getting illegal UTF8 encoding errors and I have traced it to
>> the £ sign.
>
> What's the exact error message?
>
>> I have set lc_monetary to "lc_monetary = 'en_GB.UTF-8'" in
>> postgresql.conf but
>> this has no effect. How can I sort this problem? Client_encoding
>> =UTF8.
>
> Is the data UTF-8? If the error is 'invalid byte sequence for
> encoding
> "UTF8": 0xa3' then you probably need to set client_encoding to latin1,
> latin9, or win1252.

Why?

--
Giorgio Valoti

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Garry Saddington 2008-06-18 06:30:41 Re: UTF8 encoding problem
Previous Message Craig Ringer 2008-06-18 04:27:32 Re: Need Help Recovering from Botched Upgrade Attempt