Bug #31519 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPL
Submitted: 10 Oct 2007 21:20 Modified: 10 Nov 2007 22:29
Reporter: Diego Jaramillo Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:My SQL 5.0.16-standard OS:Linux (suse 9 enterprise)
Assigned to: CPU Architecture:Any

[10 Oct 2007 21:20] Diego Jaramillo

I'm new with MySQL Server, I was created 4 views, and I need select these views using "UNION" command, but when I execute the select the client send me this error:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'UNION' Err.No 1267

The Client is "My SQL Query Browser Version 1.2.8 Beta"

if I select each view one to one, these work (return the info).

Thanks for any help 
(maybe this is a easy or stupid problem)

How to repeat:
1. create 4 views
2. select * from view1
   select * from view2
   select * from view3
   select * from view4
[10 Oct 2007 22:29] Sveta Smirnova
Thank you for the report.

But version 5.0.16 is old. Please upgrade to current version 5.0.45, try with it and if you can repeat described behaviour provide output of SHOW CREATE VIEW for every VIEW in the query and output of SHOW CREATE TABLE for every underlying table in the view.

Btw most probably this is not a bug. Please read carefully how MySQL processes  character sets and collations at http://dev.mysql.com/doc/refman/5.0/en/charset.html
[11 Nov 2007 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".