#HY000Illegal mix of collations for operation 'concat'
Posted by: Chris Cline
Date: November 16, 2004 08:35AM

How is it I can run this query:

SELECT product_id, product.product_abrev,product.product_author_id,product.Product_Title, product.product_isbn, product.product_code, product.product_package_style, customer.customer_first_name, CONCAT( customer.customer_first_name, ' ',customer.customer_initial,' ', customer.customer_last_name) AS FullName FROM product left join customer on product.product_author_id = customer.customer_id WHERE product_isactive = 0

using the MySql Query Browser and MySql 4.1 with no errors returned, but when I run the same query using 1.0.1 .Net Connector and 4.1 MySql I get

#HY000Illegal mix of collations for operation 'concat'

I have converted all of my tables so they are all latin and MySql Administrator shows them as latin.

Any idea?

Options: ReplyQuote

Written By
#HY000Illegal mix of collations for operation 'concat'
November 16, 2004 08:35AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.