I ran a search through the mySQL manual and google and could not find a satisfactory answer. Does mySQL support the declaration of a boolean data type? Currently I am using VARCHAR(6)s with either 'TRUE' or 'FALSE' and would like to cut down on the storage.
I use tinyint, and populate the fields with either 1 or 0 for True and False, respectively. This translates well to languages such as Python, which also use 1 and 0 to indicate boolean states.
___/ / __/ / ____/ Ed Leafe http://leafe.com/ http://opentech.leafe.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]