Thread: Boolean Value

    #1
  1. No Profile Picture
    cdavis
    Guest
    Devshed Newbie (0 - 499 posts)
    Does MySQL have a boolean (true/false) datatype?

  2. #2
  3. No Profile Picture
    Imo
    Guest
    Devshed Newbie (0 - 499 posts)
    could try enum('0','1')

    or

    <cut from http://www.listquest.com/lq/view.cgi?ln=mysql&mid=10917&sp=&q=boolean+data+type&b=1&s=1&o=0&ci=c052320178 >

    I think you should use and tinyint(1) for this until MySQL has the BIT
    type. This will optimized to take up only one bit in the table.

    </cut>

Similar Threads

  1. Return type for boolean functions in C
    By techgal in forum C Programming
    Replies: 3
    Last Post: October 22nd, 2003, 01:58 AM
  2. how to assing cdrom in shell
    By wyldKard in forum Visual Basic Programming
    Replies: 4
    Last Post: October 19th, 2003, 11:59 AM
  3. boolean full text search not working as expected
    By bakedbean in forum MySQL Help
    Replies: 0
    Last Post: May 8th, 2003, 12:14 PM
  4. Replies: 25
    Last Post: September 30th, 2002, 07:34 PM
  5. what is faster with selecting (boolean or integer)
    By Rooseboom in forum MySQL Help
    Replies: 9
    Last Post: June 7th, 2002, 10:53 AM

IMN logo majestic logo threadwatch logo seochat tools logo