JOIN databases of different charsets

Hi, We several databases in informix, some are utf-8, others are iso-8859-1. Is it possible to do a JOIN query from the two databases without getting a "database locale mismatch"? I think the problem is ifx needs to compare data in different charsets internally for the JOIN, which is not possible. But maybe there's a way to force internal charset conversion for the JOIN even if it would result in slow queries. We're planning on migrating more databases from ISO-8859 to UTF-8 and it would help immensely to be able to JOIN two databases of different charsets during the migration period. Running Informix 11.70.UC1. Regards, Aleksander Kamenik System Administrator Krediidiinfo AS an Experian Company Phone: +372 665 9649 Email: aleksander@krediidiinfo.ee