ehm, why do i say INT(1) then, and not just INT? but one could also take a 1 char type and perform some AND and OR on that one by hand. it's not really fast but it's possible right now. and it should be possible to convert the table later (for version 5.1 maybe) and with a little abstraction in the programme code, it shouldn't be too hard.
-yves -----Ursprüngliche Nachricht----- Von: "Phil Bitis" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Sonntag, 13. Juli 2003 19:57 Betreff: Re: does mySQL support a boolean data type? > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
