Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9CAB977E9 for ; Fri, 9 Dec 2011 08:43:48 +0000 (UTC) Received: (qmail 13765 invoked by uid 500); 9 Dec 2011 08:43:48 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 13641 invoked by uid 500); 9 Dec 2011 08:43:46 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 13621 invoked by uid 99); 9 Dec 2011 08:43:44 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Dec 2011 08:43:44 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [148.87.113.117] (HELO rcsinet15.oracle.com) (148.87.113.117) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Dec 2011 08:43:33 +0000 Received: from ucsinet22.oracle.com (ucsinet22.oracle.com [156.151.31.94]) by rcsinet15.oracle.com (Switch-3.4.4/Switch-3.4.4) with ESMTP id pB98hBSk021558 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Fri, 9 Dec 2011 08:43:12 GMT Received: from acsmt356.oracle.com (acsmt356.oracle.com [141.146.40.156]) by ucsinet22.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id pB98hB72006324 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Fri, 9 Dec 2011 08:43:11 GMT Received: from abhmt116.oracle.com (abhmt116.oracle.com [141.146.116.68]) by acsmt356.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id pB98h5Yb022561 for ; Fri, 9 Dec 2011 02:43:05 -0600 Received: from [10.172.139.195] (/10.172.139.195) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Fri, 09 Dec 2011 00:43:05 -0800 Message-ID: <4EE1CA16.809@oracle.com> Date: Fri, 09 Dec 2011 09:43:02 +0100 From: Bernt Marius Johnsen Reply-To: bernt.johnsen@oracle.com Organization: Oracle User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.21) Gecko/20110831 Thunderbird/3.1.13 MIME-Version: 1.0 To: derby-user@db.apache.org Subject: Re: German Sharp S and UCASE References: <20111208122118.123970@gmx.net> <4EE0D4C8.1040808@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Source-IP: ucsinet22.oracle.com [156.151.31.94] X-CT-RefId: str=0001.0A090208.4EE1CA20.0148,ss=1,re=0.000,fgs=0 X-Virus-Checked: Checked by ClamAV on apache.org Generally, in Unicode, it can't be assumed that length(string) == length(uppercase(string)) or that length(string) == length(lowercase(string)) So it's not a German-specific feature, and there is obviously a bug in Derby based on that wrong assumption. Furthermore in the same vein, it can't be assumed that uppercase(lowercase(uppercasestring)) == uppercasestring nor that lowercase(uppercase(lowercasestring)) == lowercasestring (e.g. lowercase(uppercase('stra�e')) gives 'strasse') Bernt