|
|
Posted by laredotornado@zipmail.com on 11/09/07 22:42
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
Navigation:
[Reply to this message]
|