By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

Yes/No Datatype

P: 78
I am new to mySQL and am working on making a replacement database for out current access database.

I am trying to plan for the yes/no datatype in access. From what I understand, the mySQL equivelent is the TINYINT datatype.

Using the TINYINT datatype, what value would be considered "true/yes"? Would it be "1 for yes/true" and "2 No/False"?

Is it truly down to what I make it? Just a matter of consistency.

Thanks for taking the time to answer this!!!
Jan 11 '12 #1

✓ answered by Rabbit

The equivalent would be a bit(1), where the valid values are 0-1. And yes, it comes down to what you make it.

Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,349
The equivalent would be a bit(1), where the valid values are 0-1. And yes, it comes down to what you make it.
Jan 11 '12 #2

P: 3
try ENUM data type,,.
Feb 7 '12 #3

P: 78
@vslsanthosh

Thank you for the suggestion; I am also using that approach in certain circumstances.
Feb 8 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.