[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

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
0
spoowiz
Asked:
spoowiz
1 Solution
 
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
 
hernst42Commented:
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
 
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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now