I am hoping that a MySQL person will give a definite answer to my question.
Thanks, Stephen ----- Original Message ----- From: "Dan Nelson" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, May 20, 2002 3:18 PM Subject: Re: [7241] Indexes on columns that are declared differently? > In the last episode (May 20), Stephen Brownlow said: > > The MySQL online manual says that MySQL cannot use indexes > > efficiently unless the columns have the same type and the same > > length. > > > > I can see no release notes that this problem has been fixed. > > > > My question: Is this still a problem? > > Probably. I doubt anyone's even trying to fix it, since a field-length > mismatch between related fields means that one or the other fields has > the wrong length. You'll never get a 20-character string to match if > the other table's field definition is char(10); either make both 10, or > both 20 :) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php