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

I can tell you that if I remove the single quotes from the CONCAT() function I do not get the error when using .Net Connector 1.0.1 and MySql 4.1.

Is this related to the Character set problem with the provider? If so, what is the work around to put some blank spaces in my concat then?


Options: ReplyQuote

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

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.