[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Newbie Q: Booleans??
From:       Zak Greant <zak () mysql ! com>
Date:       2003-01-31 21:18:28
[Download RAW message or body]

On Fri, Jan 31, 2003 at 10:16:05PM +1030, David Hefford wrote:
> Have used many databases but am just getting into MySQL and am totally rapt
> about it :) I am writing a front end in realBasic that needs to be able to
> run on various backends, MySQL being the main one. All of the others have a
> boolean type of column. What is the general practice to ?mimic? a BOOLEAN
> field in MySQL? PS: I do not need NULL or date for example, I just need true
> or false, yes or no etc...

  Hello David,

  Column types BIT/BOOL are available. (However, they are mappings to
  TINYINT(1). :)

  Perhaps check the list archives - this question has been asked in the
  past as well. IIRC, there are discussions on whether or not it should
  be implemented.

  Cheers!
-- 
 Zak Greant <zak@mysql.com> | MySQL Advocate |  http://zak.fooassociates.com

MySQL Tip: Use your favorite editor to edit queries within the mysql client
  mysql> \e

"While we are postponing, life speeds by."            --Lucius Annaeus Seneca

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread131386@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[prev in list] [next in list] [prev in thread] [next in thread]