MySQL Forums
Forum List  »  Install & Repo

Msg: "Illegal mix of collations..."
Posted by: Kostis Magh
Date: October 27, 2004 10:57AM

Hi,
My environment WinXP + Apache 1.3 + PHP 5.0.2 + MySQL 4.1.6 gamma
I can connect with no problem to a mysql db, using the mysql_connect functions.

I try to connect using the mysqli_connect functions, and I get the following message.
Error executing query: Illegal mix of collations (greek_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
SELECT <field> FROM <table> WHERE ....

I created a new db, but the msg persists...
What that means? MySql was installed with collation option : greek.

I upgrated to 4.1.7, but nothing...

Any sugestion?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Msg: "Illegal mix of collations..."
October 27, 2004 10:57AM


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.