Description:
------------
Hello,

im working on some mysql-connections and queries, and now im getting the mysql-error messages of "Illegal mix of collations". So i changed everthing to the right collation. in my case, latin1_german1_ci. Now, also setting the right collation right before sending the query, mysql seems to ingnore the charset. it looks that php sends its mysqlcommand with some precompiled collations.

Now, i'm wondering if this is a bug in php or not. did i miss something?

thanks in advance

Actual result:
--------------
array(7) {
  [0]=>
  array(2) {
    ["variable_name"]=>
    string(20) "character_set_client"
    ["value"]=>
    string(6) "latin1"
  }
  [1]=>
  array(2) {
    ["variable_name"]=>
    string(24) "character_set_connection"
    ["value"]=>
    string(6) "latin1"
  }
  [2]=>
  array(2) {
    ["variable_name"]=>
    string(22) "character_set_database"
    ["value"]=>
    string(6) "latin1"
  }
  [3]=>
  array(2) {
    ["variable_name"]=>
    string(21) "character_set_results"
    ["value"]=>
    string(6) "latin1"
  }
  [4]=>
  array(2) {
    ["variable_name"]=>
    string(20) "character_set_server"
    ["value"]=>
    string(6) "latin1"
  }
  [5]=>
  array(2) {
    ["variable_name"]=>
    string(20) "character_set_system"
    ["value"]=>
    string(4) "utf8"
  }
  [6]=>
  array(2) {
    ["variable_name"]=>
    string(18) "character_sets_dir"
    ["value"]=>
    string(26) "/usr/share/mysql/charsets/"
  }
}



array(3) {
  [0]=>
  array(2) {
    ["variable_name"]=>
    string(20) "collation_connection"
    ["value"]=>
    string(17) "latin1_german1_ci"
  }
  [1]=>
  array(2) {
    ["variable_name"]=>
    string(18) "collation_database"
    ["value"]=>
    string(17) "latin1_german1_ci"
  }
  [2]=>
  array(2) {
    ["variable_name"]=>
    string(16) "collation_server"
    ["value"]=>
    string(17) "latin1_german1_ci"
  }
}



Fatal error: 1267 - Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='