What is the field type in mySql which corresponds to Visual Basic's boolean type?

Posted on 2007-07-19
Last Modified: 2008-03-03
What is the field type in mySql which corresponds to Visual Basic's boolean type?
Question by:spoowiz
    LVL 35

    Expert Comment

    There is not a directly corresponding type,

    you could have an integer field that has a size of 1

    or I generally have an enum which responds to "True" and "False" as the two variables.
    LVL 48

    Accepted Solution

    You can use
    These types are synonyms for TINYINT(1). A value of zero is considered false. Non-zero values are considered true:
    LVL 13

    Expert Comment

    If MySQL is anything like SQL Server (which I thought it was?), then the "bit" data type is automatically translated from Boolean when using ADO.

    Author Comment


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now