Re: inserting non-ascii characters - Mailing list pgsql-novice

From Peter Schonefeld
Subject Re: inserting non-ascii characters
Date
Msg-id MLEOIJCPDKMMGACMJGHDKEDFHIAA.peter.schonefeld@bigpond.com
Whole thread Raw
In response to Re: inserting non-ascii characters  (Andreas Seltenreich <andreas+pg@gate450.dyndns.org>)
List 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
> --


pgsql-novice by date:

Previous
From: Andreas Seltenreich
Date:
Subject: Re: inserting non-ascii characters
Next
From:
Date:
Subject: ...ADD CONSTRAINT "$1"... ?