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

What is the field type in mySql which corresponds to Visual Basic's boolean type?
thanks
spoowizAsked:
Who is Participating?
 
hernst42Connect With a Mentor Commented:
You can use
BOOL, BOOLEAN
These types are synonyms for TINYINT(1). A value of zero is considered false. Non-zero values are considered true:
http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
0
 
Raynard7Commented:
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.
0
 
jmundsackCommented:
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.
0
 
spoowizAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.