Bug #18772 MySQL error 1267:Illegal mix of collations
Submitted: 4 Apr 2006 13:49 Modified: 14 Jul 2006 15:16
Reporter: [ name withheld ] Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.19 OS:Linux (Suse Linux 10.0)
Assigned to: CPU Architecture:Any

[4 Apr 2006 13:49] [ name withheld ] 
Description:
MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

Note:  I already set all system variables for character set to UTF-8 for both server and client side.

How to repeat:
you can use a select query with UNION
[4 Apr 2006 14:00] Valeriy Kravchuk 
Thank you for a problem report. Please, send your my.cnf, SHOW VARIABLES like 'char%' and exact SELECT statement with UNION.
[4 May 2006 23: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".
[14 Jul 2006 15:16] Valeriy Kravchuk 
Duplicate of bug #15949. Fixed in 5.0.20 and newer versions.