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