hi
i know this has been discussed before, storing bools
in the right column type. in the case of enum as:
enum("N","Y") or "n","y", etc. it might be easy to
read when u're looking at the database table itself,
but if u had to communicate this properly to other
programmers designing a front-end, they wouldn't be
checking for BOOLS, rather for: if ($value=="Y") { }
else { }
(add to this, the case of string or char, which would
matter more when using a C program or any other
language that doesn't type cast as per the convenience
of the statement)
is there any combination that would facilitate using
it as just: if ($value) { //true } else { //false } ?
i think enum(NULL, "") is the only option since a NULL
would imply false or 'not true' in most languages. the
second value could be "1" for clarity (as opposed to
empty strings). but i was looking for a better option.
checking for isnull, etc. is almost the same problem
as the first case, which is easier to read if we had
to.
thanks
abs
________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
