Running a query across collations

Hi there,

I'm using MySQL 5.0. When I'm trying to run a join query across
tables, I'm getting an error ...


mysql> SELECT DV.VENDOR_ID, UA.USER_ID FROM DEFAULT_VENDOR DV, VENDORS
V, (SELECT * FROM remanr_SA_REFILL5.USER_ACCOUNTS) UA WHERE
DV.VENDOR_ID = V.VENDOR_ID AND V.EMAIL = UA.EMAIL;
ERROR 1267 (HY000): Illegal mix of collations
(latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for
operation '='


Do I have to change the collation on my tables or is there a way I can
get and compare the data out of the one column without having to alter
collations?


Thanks, - Dave