<html><head><style type='text/css'>p { margin: 0; }</style><style type='text/css'>body { font-family: 'Times New Roman'; font-size: 12pt; color: #000000}</style></head><body>Agreed. I should also note that space efficiency is lower priority to me than other goals.<br><br>If space doesn't matter to me, I tend to use TINYINT(1) NOT NULL for booleans. I'm sure there's a reasonably portable way to use something like that.<br><br>----- "Khalid Baheyeldin" <kb@2bits.com> wrote:
<br>> <link href="/zimbra/css/msgview.css?v=080321143141" rel="stylesheet">One more -1 vote for bit masks stored in the database on columns<br>> that need to be filtered by. <br>> +1 on using an int or char(1) for each of the columns would be more <br>> effective, since each discrete column can be used in WHEREs, ...etc.<br>>
<br>> The extra bytes overhead is negligible.<br>> This is also more portable across databases and does not require <br>> database specific functions.<br>>
</kb@2bits.com></body></html>