It means you have a problem with the way either your tables, columns, database, or connection
Firstly do a show create table and check that the character set for the table(s) concerned are the same and that any 'character' column has the same set as the table. If you set the default char set at database level and the default on the table is different you'll need to wrap your query with a set character set pair - the first to set it to what you need and the second to set it back to the default. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://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 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 to look after it on the net, but couldn't find anything > meaningful. > > > thanks in advance, > -Eli. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] ************************************************************************************** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ************************************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
