[Vtigercrm-developers] database booleans
Adam Heinz
amh at metricwise.net
Thu May 31 09:37:58 PDT 2012
Whoops. I just wasted a few minutes because I forgot that for
vtiger_products.discontinued, 0 means true and 1 means false, but for
vtiger_crmentity.deleted, 1 means true and 0 means false. Has any
thought been given to consistently representing booleans in the
database? Per mysql documentation
http://dev.mysql.com/doc/refman/5.1/en/numeric-type-overview.html
BOOL, BOOLEAN
These types are synonyms for TINYINT(1). A value of zero is
considered false. Nonzero values are considered true:
More information about the vtigercrm-developers
mailing list