On Sun, 30 Dec 2007 17:12:54 -0800 (PST), Junkone
<junkone1@gmail.com> wrote:

>When i try to change the default data. it throws error Invalid default
>value for 'scannable'
>
>ALTER TABLE dbtrader.alerts
> CHANGE scannable scannable BIT DEFAULT '1';

'1' is a text string.
I guess BIT will only accept numeric values 0 and 1,
without quotes.

HTH
--
( Kees
)
c[_] I'm fascinated by the way memory diffuses fact. (#125)