I've found a glaring problem with the latest ODBC connector. Data types have
been changed and data is no longer being read correctly.
I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The
following query produces different data types depending on the version of the
ODBC driver.
SELECT ConCat(21000,'-','a')
In 3.51.19 it is a VarChar and in 3.51.22 it's a VarBinary. Concat is supposed
to return a string. In C a byte array may be fine but in VB a string should be
a VarChar.
Is this a bug or is there a server or OBDC setting that can be changed to make
sure that it always returns a VarChar
Thanks for the help
