|
|
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.
Navigation:
[Reply to this message]
|