Postgresql 7.4 on cygwin, upper() does not work with german special characters (umlaut)

Lists: pgsql-cygwin
From: sebastian grunow <sebastian(dot)grunow(at)web(dot)de>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Postgresql 7.4 on cygwin, upper() does not work with german special characters (umlaut)
Date: 2003-12-08 07:31:35
Message-ID: 3FD428D7.8040505@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

Hi all,

we are running postgresql 7.4 under cygwin (the package delivered with
cygwin)
under german Windows XP Professional SP1 an we experience the following
problem:

- first off all we are not able to enter german special characters such
as ÄÖÜ in
the cygwin shell, but we are able to enter them in an editor (eg. vi).
That should not
be too bad...
- when we perform a "select upper('ÄäÖöÜüAaOoUu');" we get the following
result:

upper
---------------
ÄäÖöÜüßAAOOUU
(1 row)

The special characters are not converted to capital letters! If we run
the same query against postgresql 7.4 on a linux-platform the special
characters are correctly returned in capital letters.
Any suggestions or solutions are welcome!

Kind regards
Sebastian

From: Jason Tishler <jason(at)tishler(dot)net>
To: sebastian grunow <sebastian(dot)grunow(at)web(dot)de>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Postgresql 7.4 on cygwin, upper() does not work with german special characters (umlaut)
Date: 2003-12-09 00:06:41
Message-ID: 20031209000641.GA1436@tishler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

Sebastian,

On Mon, Dec 08, 2003 at 08:31:35AM +0100, sebastian grunow wrote:
> The special characters are not converted to capital letters! If we run
> the same query against postgresql 7.4 on a linux-platform the special
> characters are correctly returned in capital letters. Any suggestions
> or solutions are welcome!

If the above is locale related, then the following from the README is
applicable:

3. Cygwin PostgreSQL only supports the "C" locale because Cygwin
itself does not fully support locales.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6