From: service prodat <service@prodat-sql.de>
To: pgsql-admin@postgresql.org
Subject: UNIX vs Windows LC CTYPE and UPPER mu
Date: Wed, 18 Apr 2012 14:03:15 +0200
Message-ID: <jmmai3$15o3$1@news.hub.org> (raw)
Hello,
first: i hope im right here in this mailing list.
My problem:
We have several Postgre servers 9.0.4, one on Windows Server 2008 R2 and
others on different UNIX/Linux systems.
Windows: LC_CTYPE = 'German, Germany'
UNIX: LC_CTYPE='de_DE.UTF-8'
(so LC_COLLATE is too)
on both systems
ENCODING = 'UTF8'
Now the function UPPER('µ') works right on Windows, giving me 'µ'
(unicode = 181 respectivly U+00B5).
On Unix I get a char like M (unicode = 924 respectivlyU+039C), the GREEK
CAPITAL LETTER MU
But we are not in Greek.
Is this a Unix based problem with a wrong local setup (we dont think so,
servers local working on other german letters like ä, ö, ü and UPPER too),
or a Unix local problem in principle,
or a wrong postgre server setup,
or a postgre bug?
Or is this a feature, not a bug.
We dont know where to search or where to fix something.
Thank you for concerning,
Dominik
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: service@prodat-sql.de
Subject: Re: UNIX vs Windows LC CTYPE and UPPER mu
In-Reply-To: <jmmai3$15o3$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox