int(1) takes up 4 bytes worth of space, and just displays 1 character. BIT or TINYINT(1) take up 1 byte.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, July 13, 2003 6:05 PM Subject: Re: does mySQL support a boolean data type? why don't you use int(1) and set it to 0 or 1? -yves -----Ursprüngliche Nachricht----- Von: "Dan Anderson" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Sonntag, 13. Juli 2003 18:41 Betreff: does mySQL support a boolean data type? > 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. > > Thanks in advance, > > Dan Anderson > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
