Chaitanya Lakshmi
  • About Me
  • Job Duties
  • Knowledge Blog
  • Applications
  • Contact Us
    • Linked In
    • Facebook
  • About Me
  • Job Duties
  • Knowledge Blog
  • Applications
  • Contact Us
    • Linked In
    • Facebook

Explain the difference between BOOL, TINYINT and BIT

4/8/2012

0 Comments

 
  • BIT data type can store up to 8 bytes from My SQL version 5.0.3
  • BIT data type can be used only for binary data
MySQL BOOL, TINYINT and BIT - September 30, 2009 at 18:00 pm by Vidya SagarExplain the difference between BOOL, TINYINT and BIT in MySQL.BOOL: Used to store Boolean values, 0 being false and 1 being true. MySQL sets them as TINYINT type.
TINYINT: The range of this data type is -128 - +127 or 0 – 256 and occupies 1 byte.
BIT: Bit uses 8 bytes and stores only binary data.

0 Comments



Leave a Reply.

    Archives

    April 2012
    March 2012
    February 2012

    Categor

    All
    Ajax
    Api
    Cross Site Scripting
    Css
    Curl
    Design Patterns
    Drupal
    Exception Handling
    Htaccess
    Html
    Javascript
    Jquery
    Json
    Linux
    Mysql
    Oops
    Php
    Regular Expressions
    Web 2.0
    Webservices
    Wordpress
    Xhtml

    RSS Feed

Powered by Create your own unique website with customizable templates.