> 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.
Sorry to give you a hit-and-run answer, but I think I read something in the on-line manual about case problems with file names on some OSses. Might have something to do with it. -- Joel Rees <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]