Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 21450 invoked from network); 4 Apr 2007 18:58:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Apr 2007 18:58:52 -0000 Received: (qmail 92180 invoked by uid 500); 4 Apr 2007 18:58:58 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 92147 invoked by uid 500); 4 Apr 2007 18:58:58 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 92138 invoked by uid 99); 4 Apr 2007 18:58:58 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 11:58:58 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [32.97.110.154] (HELO e36.co.us.ibm.com) (32.97.110.154) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 11:58:49 -0700 Received: from d03relay02.boulder.ibm.com (d03relay02.boulder.ibm.com [9.17.195.227]) by e36.co.us.ibm.com (8.13.8/8.13.8) with ESMTP id l34IwSQS018709 for ; Wed, 4 Apr 2007 14:58:28 -0400 Received: from d03av03.boulder.ibm.com (d03av03.boulder.ibm.com [9.17.195.169]) by d03relay02.boulder.ibm.com (8.13.8/8.13.8/NCO v8.3) with ESMTP id l34IwSdw155584 for ; Wed, 4 Apr 2007 12:58:28 -0600 Received: from d03av03.boulder.ibm.com (loopback [127.0.0.1]) by d03av03.boulder.ibm.com (8.12.11.20060308/8.13.3) with ESMTP id l34IwSdC021619 for ; Wed, 4 Apr 2007 12:58:28 -0600 Received: from [127.0.0.1] (DMCSDJDT41P.usca.ibm.com [9.72.133.51]) by d03av03.boulder.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id l34IwRYa021519 for ; Wed, 4 Apr 2007 12:58:28 -0600 Message-ID: <4613F528.2000004@apache.org> Date: Wed, 04 Apr 2007 11:57:44 -0700 From: Daniel John Debrunner User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: [jira] Updated: (DERBY-2524) DataTypeDescriptor(DTD) needs to have collation type and collation derivation. These new fields will apply only for character string types. Other types should ignore them. References: <6764026.1175710952245.JavaMail.jira@brutus> <4613F3FE.8030704@apache.org> In-Reply-To: <4613F3FE.8030704@apache.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Daniel John Debrunner wrote: > Why string constants for derivation though, why not integer values? > Also there's no constant for error, though I would not recommend having > an error value. Why not just use none as the default value? That will > lead to the same behaviour, no collation suppported. Adding an error > state is something that is not in the SQL standard. sorry misread error as explicit since I was expecting an explicit type to be defined. Still, not sure why an "error" state is needed. Dan.