Re: #HY000Illegal mix of collations for operation 'concat'
Posted by: lord soth
Date: November 09, 2004 07:56AM

Nobody has any suggestions as to why this is happening?

Well it seems as though when upgrading from Mysql 4.0 to Mysql 4.1 my tables were in a utf8 character format set. Currently MySql 4.1 is defaulted to latin1 as you can see from my previous posts. I just wrote a small sql script to convert all my fields within the database to the character set of utf8 and it all works fine now.

It seems as though the MySql Connector can't handle the latin1 character set that MySql 4.1 defaults to. Anybody have any idea as to why it can't handle it???


Options: ReplyQuote

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.