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';

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)