I got an
"Illegal mix of collations (latin1_swedish _ci,IMPLICIT) and
(utf8_general_c i,IMPLICIT) for operation '='"
but when I do a 'show create table', I see that my two tables are in
default charset latin1.
'show variables like '%colla%'' gives me :
| collation_conne ction | latin1_swedish_ ci |
| collation_datab ase | latin1_swedish_ ci |
| collation_serve r | latin1_swedish_ ci |
mysql version is 4.1.7.
What's wrong ?
"Illegal mix of collations (latin1_swedish _ci,IMPLICIT) and
(utf8_general_c i,IMPLICIT) for operation '='"
but when I do a 'show create table', I see that my two tables are in
default charset latin1.
'show variables like '%colla%'' gives me :
| collation_conne ction | latin1_swedish_ ci |
| collation_datab ase | latin1_swedish_ ci |
| collation_serve r | latin1_swedish_ ci |
mysql version is 4.1.7.
What's wrong ?