Re: inserting non-ascii characters

From: "Peter Schonefeld" <peter(dot)schonefeld(at)bigpond(dot)com>
To: "Andreas Seltenreich" <andreas+pg(at)gate450(dot)dyndns(dot)org>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: inserting non-ascii characters
Date: 2005-09-10 06:47:38
Message-ID: MLEOIJCPDKMMGACMJGHDKEDFHIAA.peter.schonefeld@bigpond.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Andreas,

Thanks for the fix!!

Cheers
Pete

> I guess your client_encoding does not match the encoding of your data.
> If the 0xfc is the "ü" in "müller", then your data is probably encoded
> as latin-1 / iso-8859-1.
>
> set client_encoding to 'iso-8859-1';
>
> before your statements should set up proper conversion.
>
> HTH
> Andreas
> --

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message kynn 2005-09-10 16:44:14 ...ADD CONSTRAINT "$1"... ?
Previous Message Chris Browne 2005-09-10 05:40:08 Re: Database Migration