db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Raynsford <list+org.apache.db.derby-u...@io7m.com>
Subject Re: Constants for CHAR() FOR BIT DATA?
Date Sat, 28 Sep 2019 16:02:15 GMT
On 2019-09-28T08:43:21 -0700
Rick Hillegas <rick.hillegas@gmail.com> wrote:

> On 9/28/19 2:11 AM, Mark Raynsford wrote:
> > create table core.users (
> >    user_id                    char (16) for bit data not null,
> >    user_password_hash_algo    varchar (64) not null,
> >    user_password_hash         varchar (64) not null,
> >    user_email                 varchar (128) not null,
> >    user_display_name          varchar (128) not null,
> >    user_locked                boolean not null,
> >
> >    constraint user_id_key primary key (user_id),
> >    constraint user_id_nonzero check (user_id !=
> >    cast('\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0' as char(16) for bit data)),
> >    constraint user_display_name_unique unique (user_display_name))  
> 
> Hi Mark,
> 
> The SQL Standard syntax for BINARY literals is a little odd. It is
> 
>    X'<sequence of hex digits>'

Hello!

Thanks very much, that's what I was looking for!

-- 
Mark Raynsford | http://www.io7m.com


Mime
View raw message