Set bit to TRUE/FALSE
Posted: Wed Aug 29, 2012 8:16 pm
Hello,
I'm trying to store a value in a BIT data type as True/False
But I have troubles to set it to True.
It also doesn't show FALSE when I do a select.
Anyone know how to solve this?
I'm trying to store a value in a BIT data type as True/False
Code: Select all
CREATE TABLE test
(
id VARCHAR(40) PRIMARY KEY,
value BIT DEFAULT FALSE
);
It also doesn't show FALSE when I do a select.
Anyone know how to solve this?