I didn't think mysql had logical field types so it must be character then if it is returning '1' or '0'. In sqlserver, a bit is typically used returning 1 or 0 for true and false.


I checked here and I don't see logical:

http://help.scibit.com/Mascon/masconMySQL_Field_Types.html



>We're moving a table from VFP8 to MySql. To get the data from it we had been running the following

>SELECT DISTINCT * FROM myTable

>
>There are two logical fields which are returned. When the same query is run against the MySQL version, the logical fields are converted into Character (with 1's and 0's).
>
>The good news is that there should not be duplicate records in the table and removing the DISTINCT portion gives me back the correct structure.
>
>I'm curious if this is correct behavior, or if we have a problem with the migration. I'm also curious if this behavior would be repeated with a different back-end (SQL-Server, DB2, etc.)
>
>Thanks to all...............Rich