I am hoping that a MySQL person will give a definite answer to my question.
Thanks,
Stephen
----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
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 :)
