Gayner Posted September 27, 2009 Share Posted September 27, 2009 Im making a row on my table, but it's only to be used for 0 and 1, simple true and false 1 and 0 what type should i do that is the smallest most less performanced? a varchar(2)? or somethinG? Ty Quote Link to comment Share on other sites More sharing options...
.josh Posted September 27, 2009 Share Posted September 27, 2009 personally i'd go for tinyint Quote Link to comment Share on other sites More sharing options...
redarrow Posted September 27, 2009 Share Posted September 27, 2009 my choice ENUM('0','1') NOT NULL default '0' Quote Link to comment Share on other sites More sharing options...
.josh Posted September 27, 2009 Share Posted September 27, 2009 except that enum takes up more space by storing the possible values. Quote Link to comment Share on other sites More sharing options...
Gayner Posted September 27, 2009 Author Share Posted September 27, 2009 tiny it. thank u guys! Quote Link to comment Share on other sites More sharing options...
fenway Posted October 5, 2009 Share Posted October 5, 2009 Technically, CHAR(0) is the smallest you can use for storing booleans. Quote Link to comment Share on other sites More sharing options...
Mchl Posted October 5, 2009 Share Posted October 5, 2009 A column that is defined as CHAR(0) NULL occupies only one bit and can take only the values NULL and '' (the empty string). Wicked... but testing against '' and NULL can be quite counter intuitive... Wicked... Quote Link to comment Share on other sites More sharing options...
fenway Posted October 5, 2009 Share Posted October 5, 2009 Oh, it's pure evil.... I concur. It's more of a trivia question. Quote Link to comment Share on other sites More sharing options...
Mchl Posted October 5, 2009 Share Posted October 5, 2009 Why can't we have a real BOOL type Quote Link to comment Share on other sites More sharing options...
fenway Posted October 5, 2009 Share Posted October 5, 2009 Why can't we have a real BOOL type You mean one that isn't an alias to "TINYINT(1)"? Quote Link to comment Share on other sites More sharing options...
Mchl Posted October 5, 2009 Share Posted October 5, 2009 One that takes indeed one bit. I did some testing with BIT(1) but it just confuses me. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.