Re: Some datagard errors

>> > 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 :)

> 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