I use TINYINT. it stores 0 for false and 1 for true. I tried with enum,
but the communication with MS Access was not happening. In Code you can
treat this as a Boolean and in the UI if you have checkboxes the values of 1
or 0 also work.
HTH.
JFercan
*** sql ***
-Original Message-
From
MySQL does not have a boolean type. For yes/no or true/false information, I
usually use an enumerator (enum) and define the "false" value first and the
"true" second. (So "no" would be first and "yes" second.) Then, when I
query for the value in that field, I can ask for it minus one, and I get
[EMAIL PROTECTED] wrote:
Hi all,
After setting the field data type in MySQL to Text, which is the same data
type for Access data type where the data is being imported from, the import
process was succeful and the same number of rows was imported, BUT I
don't see any data in the MySQL, all
I use MySQLFront and is creats the tables and imports the data with one
click
never had a problem
Alan
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com]
> Sent: Wednesday, 30 October 2002 9:15
> To: [EMAIL PROTECTED]
> Subject: Access2MySQL
>
>
> Hi all,
>
> Aft
