#HY000Illegal mix of collations for operation 'concat'

[Chris Cline]

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?