Posted by Bob Bedford on 06/09/05 15:29

I've no access to mysql NG, so I ask here:

I've two identical tables (wich are created by usins the same script, but
must be separated).

When I execute a query wich return fields and do a UNION between them, I
get:
Illegal mix of collations for operation 'UNION'

I had an old mysql version on the server, and since my ISP upgraded, I have
problems with collations. The base is now in latin1_swedish_ci, and my datas
may manage french text.

Why the union doesn't work ? what do I need to do. The entire site is
working, but not this query. I get crazy.

What should I do, collation for both table are latin1_swedish_ci, and also
text fields.

[Back to original message]