[BNM] MySQL Character set problem

[Alan Braddish]

Hi,

Am having a problem comparing text from 2 tables in MySQL v4.1

I get the following error from the script:

[MySQL][ODBC 3.51 Driver][mysqld-4.1.12-nt]Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation
'='

I have changed the offending table collation type, so that they are now both
latin_1, and restarted the MySQL service, but the problem still persists.
The tables are now both reporting to have the collation type: latin1.

Anyone got any ideas?  Thanks.
Alan