Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 70601 invoked from network); 28 Dec 2005 00:15:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 28 Dec 2005 00:15:26 -0000 Received: (qmail 2538 invoked by uid 500); 28 Dec 2005 00:15:25 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 2519 invoked by uid 500); 28 Dec 2005 00:15:24 -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 2504 invoked by uid 99); 28 Dec 2005 00:15:24 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Dec 2005 16:15:24 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of tomdzk@gmail.com designates 64.233.182.198 as permitted sender) Received: from [64.233.182.198] (HELO nproxy.gmail.com) (64.233.182.198) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Dec 2005 16:15:23 -0800 Received: by nproxy.gmail.com with SMTP id l24so503125nfc for ; Tue, 27 Dec 2005 16:15:02 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=uHANQpFIH78aI4bzfyY0HFiGj513KP8SvBGkSgQC2o42wxyrMPlCBLC6vtOlITr+FriJS7D9FTYQJk7qd9rUo7MXxvxef8ds0h1hBV75BqBIYUMvivRPXLDmfFcgi2ASpnDUGdoqmQT4uO8xBn7PRfXhwToh3jTG8pXRK+BS0Tc= Received: by 10.48.234.14 with SMTP id g14mr294493nfh; Tue, 27 Dec 2005 16:15:02 -0800 (PST) Received: by 10.48.143.20 with HTTP; Tue, 27 Dec 2005 16:15:02 -0800 (PST) Message-ID: <224f32340512271615k573b7605pb0c44837de52cf3d@mail.gmail.com> Date: Wed, 28 Dec 2005 01:15:02 +0100 From: Thomas Dudziak To: Derby Discussion Subject: Re: Default value for (VAR)CHAR FOR BIT DATA columns ? In-Reply-To: <43B1790E.6020500@debrunners.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <224f32340512260614n3f0ca9ceyb185adc848a4bcca@mail.gmail.com> <43B1790E.6020500@debrunners.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 12/27/05, Daniel John Debrunner wrote: > Yes. Use literals/constants that represent VARCHAR FOR BIT DATA. > > create table t ( b varchar(20) for bit data default X'CAFE') > > The default here would be 0xCAFE Yes, I thought it would be something like that (without the X though). But how do I specify characters in e.g. the range 0 - 32 ? Is there something like an escape syntax ? Or can I use Base64 or hex ? regards, Tom