General information
Title:
MySQL select 0 as FLD1 returns character field
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only