In my website, I need to keep track of whether an Application was approved or not.
To me, there are really 3 states, though.
1.) The Application has not been seen so the "app_approved" field would be "Null"
2.) The Application has been seen and everything was okay, so the "app_approved" is "True"
3.) The Application has been seen and everything was NOT okay, so the "app_approved" is "False"
**Disclaimer, I am actually using MySQL, but I like you guys over here at UA so much I figured I'd come visit!
In MySQL, believe it or not, there actually is no "BOOLEAN" data-type yet?! So the conventional wisdom is to use "TINYINT" which is something like 0-255 unsigned and choose "0" for "False" and "1" or any other positive number for "True"
I was sorta thinking of doing this...
0 = Null
1 = True
2 = False
...but I am not sure of the implications?!
If I use a Lookup Table, I don't think my PHP code will care what I call each "State", but since this is likely a fairly common problem, I am wondering if there is a better way to handle things?
If you were doing this in MS Access or SQL Server how would you handle my 3-State problem?
And if you were doing this in MySQL - based on what I shared - what do you think would be the best approach?