Re: MS Access Checkbox equivalent format in MySQL

2001-02-07 Thread Pat Sherrill 

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


 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

Re: MS Access Checkbox equivalent format in MySQL

2001-02-06 Thread Peter Skipworth 

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