Page 1 of 1

Mysql Inner Join Error

Posted: Thu Jun 05, 2008 2:10 pm
by spanky
Hi,

When I am trying to run a query I am getting this error:

Mysql Query:SELECT fr.friend, u.email, u.type, u.lang_file FROM user AS u INNER JOIN friends AS fr ON fr.friend = u.user WHERE fr.user = "girlwat"
Mysql Error: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

Can the inner join function be used on tables and/or columns of different collations?

Thanks

Re: Mysql Inner Join Error

Posted: Thu Jun 05, 2008 2:41 pm
by Benjamin
Apparently not. Can you change one or the other?

Re: Mysql Inner Join Error

Posted: Thu Jun 05, 2008 3:10 pm
by spanky
No. I was hoping there might be a way to get around it so I could save myself a for loop of queries by still using the "join".

Re: Mysql Inner Join Error

Posted: Thu Jun 05, 2008 3:15 pm
by Benjamin
I don't know the answer to this. I would see if I could dig anything out of the MySQL manual.