I get "Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'. in a query like (SELECT ...) UNION (SELECT * INTO OUTFILE ...) to build a CSV file.
The database has default charset UTF8 and collation utf8_general_ci and all query tables have default charset UTF8 and collation utf8_general_ci MySQL client says for show variables character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_results utf8 character_set_server utf8 character_set_system utf8 collation_connection utf8_general_ci collation_database utf8_general_ci collation_server utf8_general_ci I'm using MySQL 5.0.15. Any idea why I get this "Illegal mix" error and how to solve it ? TIA, Cor
