On Wednesday 18 June 2008 02: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. > Thanks, that's fixed it. Garry
