From: service prodat <service@prodat-sql.de>
Subject: UNIX vs Windows LC CTYPE and UPPER mu
Date: Wed, 18 Apr 2012 14:03:15 +0200
Organization: Hub.Org Networking Services
Lines: 33
Message-ID: <jmmai3$15o3$1@news.hub.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:11.0) Gecko/20120327 Thunderbird/11.0.1
To: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable

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=20
others on different UNIX/Linux systems.
Windows: LC_CTYPE =3D 'German, Germany'
UNIX: LC_CTYPE=3D'de_DE.UTF-8'
(so LC_COLLATE is too)

on both systems
ENCODING =3D 'UTF8'

Now the function UPPER('=B5') works right on Windows, giving me '=B5'=20
(unicode =3D 181 respectivly U+00B5).
On Unix I get a char like M (unicode =3D 924 respectivlyU+039C), the GREE=
K=20
CAPITAL LETTER MU
But we are not in Greek.

Is this a Unix based problem with a wrong local setup (we dont think so,=20
servers local working on other german letters like =E4, =F6, =FC and UPPE=
R 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