When we do a :
"select 0 as fld1, aa from table1 into cursor table2",
in vfp and in MsSql (via sqlexec) the resulting fld1 field is numeric.

MySQL returns the fld1 as a character field. It does so even if we use the: "select cast(0 as unsigned) as fld1, aa from table1 into cursor table2".

Could odbc be doing some kind of conversion? I 've used the options = 262657 in the sqlconnect string but I don't see any difference.

Has anyone come across this before?