MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Diana Soares Date:January 31 2003 7:41pm
Subject:Re: Newbie Q: Booleans??
View as plain text  
Hi,
You have the BOOL type in MySQL which is a synonym for TINYINT(1). 
Maybe this is the best approach.

You may see the manual in "Column types" section.

On Fri, 2003-01-31 at 11:46, 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...
> 
> Regards
> 
> David Hefford
> Power On Solutions
> Web: http://www.poweron.com.au
> Email: sales@stripped
>    
> 
> 
> 
> 
> ---------------------------------------------------------------------
> 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-thread131298@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-dsoares=fc.up.pt@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
-- 
Diana Soares

Thread
Newbie Q: Booleans??David Hefford31 Jan
  • RE: Newbie Q: Booleans??Fernando Grijalba31 Jan
  • Re: Newbie Q: Booleans??Diana Soares31 Jan
  • Re: Newbie Q: Booleans??Zak Greant31 Jan