Postgres Pro
Downloads
Home   >   mailing lists

Re: UTF8 encoding problem - Mailing list pgsql-general

From Michael Fuhr
Subject Re: UTF8 encoding problem
Date
Msg-id 20080618010409.GA30622@winnie.fuhr.org
Whole thread Raw
In response to UTF8 encoding problem  (Garry Saddington <garry@schoolteachers.co.uk>)
Responses Re: UTF8 encoding problem  (Garry Saddington <garry@schoolteachers.co.uk>)
Re: UTF8 encoding problem  (Giorgio Valoti <giorgio_v@mac.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Need Help Recovering from Botched Upgrade Attempt
Next
From: Klint Gore
Date:
Subject: Re: Need Help Recovering from Botched Upgrade Attempt