I use a short (0 unchecked, 1 checked).
Pat...
- Original Message -
From: "John Halladay" <[EMAIL PROTECTED]>
To: "MySQL List (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:57 PM
Subject: MS Access Checkbox equivalent format in MySQL
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
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
