I'm coming from using MS Access and I'm used to using boolean fields in tables for yes/no true/false responses.
I'm not even sure how this is stored.
I want to avoid a pit fall in a project I'm developing.
What kind of field type do I use for this in MySQL, so that I can use PHP code to get this yes/no value properly.
I'm a beginner at PHP, and MySQL, but am a full-fledge programmer and Database Analyst.

Salvatore

__________________
Database Agreements

Then field type is ENUM.
Then the Length/Set ('Yes','No').
John

I was thinking more along the lines that in MS Access the boolean is stored merely as a byte which is unsigned, and then internally it gets converted to a true/false. Ie. in code, you have
If fynReverseKey == False, etc.

In MS Access True=-1 and False=0 (I think).
Then in PHP 0 is false, and anything else is True right?,
so, if I use tinyint, then I just call the field,
fynReverseKey to indicate its a yes/no, which has the function of telling me whether a Reverse Key flag is set.
I guess I've solved my own problem!!