error: Illegal mix of collations

[fanz]

Error Message - Error selecting sugarbean: Illegal mix of collations (gb2312_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation ' IN

Help!!

[mikke]

The same as upstair error

win2000/php5 /mysql5/sugarsuit3.0.1

[Rymar]

I had the same trouble but with cp1251 encoding

I solved the problem by adding the following strings (see function_connect, file: /include/database/PearDatabase.php):

$this->database =@mysql_pconnect($this->dbHostName,$this->userName,$this->userPassword);

mysql_query ("set character_set_client='cp1251'");
mysql_query ("set character_set_results='cp1251'");
mysql_query ("set collation_connection='cp1251_general_cs'");


I use SugarCRM 4.0.1c and now it works with Russian!