Take your pic - personally, I usually use a tinyint, and assign a 0 or 1
- I suspect the options you describe would work just as well.
regards,
P
On Tue, 6 Feb
2001, John Halladay wrote:
> If I am using MS Access and linking to tables in MySQL through MyODBC, what
> is the equivalent format of a checkbox (Yes/No) in MySQL?
>
> Would it be ENUM('Yes','No') or ENUM('True','False')? All caps TRUE, YES,
> etc.?
>
> Thanks ahead of time for your input.
>
> John Halladay
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php