RE: Error 1271 (HY000) - Illegal mix of collations

2005-02-11 Thread Kevin Cowley
://www.alchemetrics.co.uk -Original Message- From: Eli [mailto:[EMAIL PROTECTED] Sent: 11 February 2005 05:47 To: mysql@lists.mysql.com Subject: Error 1271 (HY000) - Illegal mix of collations Hi, I'm running a query using UNION, where all parts of the union are queries from the same

Re: Error 1271 (HY000) - Illegal mix of collations

2005-02-11 Thread Gleb Paharenko
using UNION, where all parts of the union are queries from the same syntax and from tables with same definition, and the select is same too. Each of the union parts is a query with JOINs. I got this error: ERROR 1271 (HY000): Illegal mix of collations for operation 'UNION' I tried

Error 1271 (HY000) - Illegal mix of collations

2005-02-10 Thread Eli
Hi, I'm running a query using UNION, where all parts of the union are queries from the same syntax and from tables with same definition, and the select is same too. Each of the union parts is a query with JOINs. I got this error: ERROR 1271 (HY000): Illegal mix of collations for operation