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