db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lars Clausen ...@statsbiblioteket.dk>
Subject Re: ij problem?
Date Wed, 07 Dec 2005 08:46:40 GMT
On tir, 2005-12-06 at 22:33, Bernt M. Johnsen wrote:
> >>>>>>>>>>>> Craig L Russell wrote (2005-12-06 10:31:57):
> > Hi Joe,
> > 
> > I think your problem is that VARCHAR needs a length, so the ")" in  
> > the "user_password VARCHAR)" (at position 161) was unexpected. It  
> > expected (20) before the closing ")".
> 
> For the record: VARCHAR without length is a non-standard feature
> allowed by some databases. Derby requires length and is thus compliant
> with the SQL standards (all of them).

Is that length used for anything?  Surely it doesn't allocate all that
anyway, so is it just for compliance?

-Lars


Mime
View raw message