Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 1B4C4F6B3CC for ; Thu, 19 Apr 2012 15:22:11 -0300 (ADT) Received: from mailout-de.gmx.net ([213.165.64.23]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1SKvze-0005iL-0I for pgsql-admin@postgresql.org; Thu, 19 Apr 2012 18:22:10 +0000 Received: (qmail invoked by alias); 19 Apr 2012 18:21:56 -0000 Received: from a88-115-218-87.elisa-laajakaista.fi (EHLO [10.0.0.108]) [88.115.218.87] by mail.gmx.net (mp019) with SMTP; 19 Apr 2012 20:21:56 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX186j7MMcyU6w118tqhDN9Lwlcuy9zouzqsyYxiDjt qJpPXmRrUkK3ux Message-ID: <1334859715.24114.3.camel@vanquo.pezone.net> Subject: Re: UNIX vs Windows LC CTYPE and UPPER mu From: Peter Eisentraut To: Albe Laurenz Cc: service prodat *EXTERN* , pgsql-admin@postgresql.org Date: Thu, 19 Apr 2012 21:21:55 +0300 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.2.2-1 Content-Transfer-Encoding: 7bit Mime-Version: 1.0 X-Y-GMX-Trusted: 0 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/109 X-Sequence-Number: 39445 On tor, 2012-04-19 at 10:02 +0200, Albe Laurenz wrote: > After looking at the UNICODE character list I tend to agree that > code point 0xB5 (MICRO SIGN) should not be converted to > 0x39C (GREEK CAPITAL LETTER MU). There's 0x3BC for GREEK SMALL LETTER MU. http://www.unicode.org/Public/UNIDATA/UnicodeData.txt has: 00B5;MICRO SIGN;Ll;0;L; 03BC;;;;N;;;039C;;039C and 039C;GREEK CAPITAL LETTER MU;Lu;0;L;;;;;N;;;;03BC; So this mapping is correct. Case conversion is not necessarily round-trip.