To whom it may concern,
I am using MySql v.4.0.13 and am trying to query the user table from Visual
Basic using ADO. If the user has an entry, that is uppercase lowercase,
e.g. Jim, and my query is:"select user from mysql.user where user ='Jim'"
the recordset returned is empty. But, if the entry in the user field is all
lowercase then, the recordset is returned with the appropriate values. I do
not know MySql well enough to know if this is a bug or not, but if I run the
query:"select user from mysql.user where user ='Jim'" in the Control center,
it works fine. Please help me with this irritating problem. I also have
the same problem if the entry in the user field is all uppercase.
Thank you,
Michael Franch
Software Engineer
UB Computer Services
(630) 910-9066 - Phone
(630) 910-0702 - Fax
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
