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?
Code: Select all
CREATE TABLE test
(
id VARCHAR(40) PRIMARY KEY,
value BIT DEFAULT FALSE
);
Code: Select all
valuename enum('true','false') NOT NULL default 'false'