You can use "BIT" or "BOOL", but these are currently just synonyms for TINYINT(1). Still your best bet though.
The manual says under new features planned for 5.1: "Optimise BIT type to take 1 bit (now BIT takes 1 char)" ----- Original Message ----- From: "Dan Anderson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, July 13, 2003 6:21 PM Subject: Re: does mySQL support a boolean data type? > > why don't you use int(1) and set it to 0 or 1? > > Storage space is an issue because I am designing a very large database > for a client. Every byte I save per row will translate into many many > megs. So if all I need is a single bit for true or false I want to get > as close to that single bit as possible. (Although most bools end up > being more then a single bit because of architecture issues). > > So, to put a long story short, I am trying to make every column's > internal data structure as tiny as possible. > > -Dan > > > -- > 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]
