Webmaster2020.com

Posted: **Wed Aug 29, 2012 8:16 pm**

Hello,

I'm trying to store a value in a BIT data type as True/False

CREATE TABLE test
(
  id VARCHAR(40) PRIMARY KEY,
  value BIT DEFAULT 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?

Posted: **Thu Aug 30, 2012 3:30 pm**

You can use TININT(1) to set a value of 1 bit (0 or 1).

But my personal favorite is EMNUM

valuename enum('true','false') NOT NULL default 'false'

note: ENUM can have more then 2 values, up to 65,535.

Set bit to TRUE/FALSE