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???
Soth
Subject
Written By
Posted
November 05, 2004 03:13PM
Re: #HY000Illegal mix of collations for operation 'concat'
November 09, 2004 07:56AM
November 09, 2004 03:59PM
November 10, 2004 08:17AM
November 11, 2004 07:18PM
November 12, 2004 12:19AM
November 13, 2004 03:30PM
November 14, 2004 04:58AM
November 14, 2004 09:06AM
November 14, 2004 10:33AM
November 15, 2004 02:30PM
November 15, 2004 09:35AM
November 12, 2004 02:02AM
November 12, 2004 09:41AM
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.