Re: UTF8 encoding problem

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UTF8 encoding problem
Date: 2008-06-18 01:04:10
Message-ID: 20080618010409.GA30622@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Klint Gore 2008-06-18 01:17:36 Re: Need Help Recovering from Botched Upgrade Attempt
Previous Message Laurent Birtz 2008-06-18 00:59:13 Forcibly vacating locks