MySQL Bugs: #31519: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general

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:	None
Category:	MySQL Server: Errors	Severity:	S2 (Serious)
Version:	My SQL 5.0.16-standard	OS:	Linux (suse 9 enterprise)
Assigned to:		CPU Architecture:	Any

Description:
hi, 

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"

Note:
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
   union
   select * from view2
   union
   select * from view3
   union
   select * from view4

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

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".