Results 1 to 3 of 3

Thread: error: Illegal mix of collations

  1. #1
    fanz is offline Junior Member
    Join Date
    Feb 2005
    Posts
    1

    Default error: Illegal mix of collations

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

    Help!!

  2. #2
    mikke is offline Member
    Join Date
    Mar 2005
    Posts
    5

    Default Re: error: Illegal mix of collations

    The same as upstair error

    win2000/php5 /mysql5/sugarsuit3.0.1


  3. #3
    Rymar is offline Junior Member
    Join Date
    Feb 2006
    Posts
    2

    Default Re: error: Illegal mix of collations

    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!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •