Mysql Inner Join Error
Posted: Thu Jun 05, 2008 2:10 pm
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
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