#36879 [Opn->Bgs]: Collation Charset of connection is unchangeable
| From: | dbarth at gmx dot net | Date: | Mon, 27 Mar 2006 22:00:14 +0000 |
| Subject: | #36879 [Opn->Bgs]: Collation Charset of connection is unchangeable | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-94939@lists.php.net to get a copy of this message | ||
ID: 36879
User updated by: dbarth at gmx dot net
Reported By: dbarth at gmx dot net
-Status: Open
+Status: Bogus
Bug Type: MySQL related
Operating System: Mandrake
PHP Version: 5.1.2
New Comment:
Sorry folks for bothering you,
sometimes it only needs an email for finding the failure...
it was my fault, i just missed a database.
Previous Comments:
------------------------------------------------------------------------
[2006-03-27 23:56:36] dbarth at gmx dot net
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 '='
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36879&edit=1