Skip site navigation (1) Skip section navigation (2)

Question about character encoding

From: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Question about character encoding
Date: 2002-02-21 13:06:29
Message-ID: 2266D0630E43BB4290742247C8910575014CE13E@dozer.computec.de (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-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

Responses

pgsql-cygwin by date

Next:From: Jean-Michel POUREDate: 2002-02-21 13:27:25
Subject: Re: [CYGWIN] Question about character encoding
Previous:From: Henshall, Stuart - WCPDate: 2002-02-21 11:19:20
Subject: Re: Poor performance

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2002-02-21 13:27:25
Subject: Re: [CYGWIN] Question about character encoding
Previous:From: Jean-Michel POUREDate: 2002-02-21 12:36:58
Subject: Re: Feature request: md5sum footprint of schema objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group