Link to home
Start Free TrialLog in
Avatar of spoowiz
spoowizFlag for United States of America

asked on

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
Avatar of Raynard7
Raynard7

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.
ASKER CERTIFIED SOLUTION
Avatar of hernst42
hernst42
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of spoowiz

ASKER

thanks