default value for bit

31/12/2007, 01h12

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

31/12/2007, 11h16

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)

31/12/2007, 11h16	#2
Kees Nuyt Messages: n/a Hébergeur:	Re: default value for bit 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)

31/12/2007, 01h12	#1
Junkone Messages: n/a Hébergeur:	default value for bit 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';

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email