Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text

Links

XODOX
Impressum

#1: Running a query across collations

Posted on 2007-11-09 23:42:58 by laredotornado

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

Report this message