SHOW FIELDS suddenly returns byte array in MyODBC 3.51
am 24.02.2008 22:57:41 von Jos Verhoeff------=_NextPart_000_0008_01C87738.A970E040
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi,
I'd been using, in a vb dll myodbc 3.51.09 for a while, and recently
installed the last version (3.51.23) on a new server, hosting for the rest,
the same MySQL version (4.1, in preparation of an upgrade) and application
making the requests
To find out about the structure of the database in use (to detect older
versions) The application issues the command "SHOW FIELDS FROM mytable" and
expects a string in the returning recordset for the "field" column
Like in :
Set recordset = DatabaseConnection.Execute("SHOW FIELDS FROM mytable")
S = recordset("field")
After installation of 3.51.23 recordset("field") (and recordset ("type")
too) contains a byte array with the character codes of the value, e.g.
instead of returning "lcode" it returns (108,99,111,100,101).
I coded a patch, but does anyone have the same problem, and why was this
done ? This is an incompatibility nobody was waiting for, or was it.
Any clues ?
CERIUM - Internet Technology
Beurs - World Trade Center - Suite 273
Beursplein 37 (bezoekadres)
Postbus 30006
3001 DA Rotterdam
T : 010 2056700
F : 010-2051938
I :
Alg. @ :
------=_NextPart_000_0008_01C87738.A970E040--