db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Dudziak <tom...@gmail.com>
Subject Re: Default value for (VAR)CHAR FOR BIT DATA columns ?
Date Wed, 28 Dec 2005 00:15:02 GMT
On 12/27/05, Daniel John Debrunner <djd@debrunners.com> 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

Mime
View raw message