Question about character encoding - Mailing list pgsql-cygwin

From Markus Wollny
Subject Question about character encoding
Date
Msg-id 2266D0630E43BB4290742247C8910575014CE13E@dozer.computec.de
Whole thread Raw
Responses Re: Question about character encoding  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgsql-cygwin
Hi!

This may be completely stupid, but I just can't figure...

I installed the latest cygwin snapshot along with PostgreSQL 7.2; I
access the DB using the latest PGAdmin II 1.2.0. Almost everything seems
to be working fine - with one major glitch: I just cannot insert nor
select strings containing german umlaute or any other special characters
into my database.

I selected Unicode as encoding (was that correct?), but when I do

INSERT INTO test VALUES (1,'this is an example string containing ä, ö,
ü, Ä, Ö, Ü, ß');

I just get "Invalid UNICODE character sequence found". So far I just
cannot store nor retrieve ordinary german text...

What do I need to do in order to get this working? So far I haven't
found any postings about people having elementary problems like this, so
I think it's just something obvious that I nevertheless fail to see -
could you please enlighten me? Is the binary that came with cygwin
compiled with locale- and multibyte-support at all?

Thanks,

    Markus

pgsql-cygwin by date:

Previous
From: Kannan
Date:
Subject: "psql" gives error.
Next
From: Jean-Michel POURE
Date:
Subject: Re: Question about character encoding