[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