Re: equvalent MySQL column type logical in FoxPro

there is no boolean type in MySQL.

You can use ENUM
eg ENUM( 'Y','N') or ENUM( '0', '1' )

or TINYINT (but your application logic must ensure only 0|1 get there)

HTH
Ignatius
_________________________
----- Original Message -----
From: "tatskie" <melchorsy@xxxxxxxxx>
To: <win32@xxxxxxxxxxxxxxx>
Sent: Saturday, August 23, 2003 12:02 PM
Subject: equvalent MySQL column type logical in FoxPro


> i am trying to evacuate my tables from foxpro7 to
> MySQL. now i have a problem with logical column type
> in foxpro. what is the equvalent column type of this
> in MySQL?
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=ignatius.reilly@xxxxxxx
>
>


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=gcdmw-win32@xxxxxxxxxxx