Re: Some datagard errors

On søn, 2006-01-29 at 20:22 +0100, Piotras wrote:
> >> > and:
> >> > ERROR 1067 (42000) at line 1: Invalid default value for
> >> > 'metadata_hidden'
> >>
> >> Can someone point me to good ANSI SQL docs?
> >> Something which is supported by MySQL 4.0, 4.1 and 5.x.
> > According to this:
> > http://dev.mysql.com/doc/refman/4.1/en/numeric-type-overview.html
> 
> no no :)
> I do read MySQL docs , but I need good ANSI SQL ones :)
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
Also I'm impressed by the postgres manual:
http://www.postgresql.org/docs/8.1/static/datatype-boolean.html

Tarjei

> > BOOL, BOOLEAN
> >
> > These types are synonyms for TINYINT(1). The BOOLEAN synonym was added
> > in MySQL 4.1.0. A value of zero is considered false. Non-zero values are
> > considered true.
> 
> I made first implementation in dg which makes db conversion to utf.
> I am not sure but looks like we will support *only* MySQL >= 4.1.
> 
> > Using 0 instead of 'FALSE' should fix the problem. That worked on 1.5 at
> > least as I patched dg my self.
> 
> 5.0, 5.1 ? ;)
> 
> Piotras
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe-b5ZhpPVuLA+tlBvVaVFjCkB+6BGkLq7r@public.gmane.org
> For additional commands, e-mail: [email protected]
> 
-- 
Tarjei Huse <tarjei-y/[email protected]>