Does Binary = Boolean? 1

[Rougy]

Hi,

Visual Basic 6 has a boolean variable. I'm using VB to transfer some data via DDE from one machine to the SQL database, and I was wondering if binary was the same as boolean, i.e. true or false, off or on, 1 or 0.

Kind of a stupid question, but my help files for SQL aren't responding.

Thanks

-----
The death of dogma is the birth of reason.

 

[cheyney]

nope, binary stores binary data (more than one bit, up to 2 GB i believe). What you're looking for is the sql data type "bit"

Cheyney

 

[Rougy]

Thanks Cheyney,

Is that a 1 or 0 value for the bit?

-----
The death of dogma is the birth of reason.

 

[cheyney]

yup,
0 is false, <>0 (e.g. 1) is true

you can't use the words true and false.

Cheyney