#HY000Illegal mix of collations for operation 'concat'
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?
Subject
Written By
Posted
#HY000Illegal mix of collations for operation 'concat'
November 16, 2004 08:35AM
November 16, 2004 08:48AM
November 16, 2004 09:31AM
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.