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
Mysql Inner Join Error
Moderator: General Moderators
Re: Mysql Inner Join Error
Apparently not. Can you change one or the other?
Re: Mysql Inner Join Error
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
I don't know the answer to this. I would see if I could dig anything out of the MySQL manual.