Quote:
error 1267 (hy000): Illegal mix of collations (latin1_swedish_ci,implicit) and (cp850_general_ci,implicit) for operation '='
|
donaldcanard [and Thalix,] you'll need to look at the tables used in the query and see which ones are using the different collations.
Whenever data is joined from multiple tables, they must be of the same collation type.