Mysql Inner Join Error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
spanky
Forum Newbie
Posts: 2
Joined: Thu Jun 05, 2008 2:05 pm

Mysql Inner Join Error

Post 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
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: Mysql Inner Join Error

Post by Benjamin »

Apparently not. Can you change one or the other?
spanky
Forum Newbie
Posts: 2
Joined: Thu Jun 05, 2008 2:05 pm

Re: Mysql Inner Join Error

Post 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".
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: Mysql Inner Join Error

Post by Benjamin »

I don't know the answer to this. I would see if I could dig anything out of the MySQL manual.
Post Reply