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
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
