I have noticed a very peculiar behavior when I upgraded my PHP
revision from 4.3.9 to 4.3.10 (I use Debian Linux). Suddenly,
the PHP MySQL client stopped accepting the default encoding / collation
when connecting to the server. When issuing any query containing text
field comparisons, I get the following error message:

Illegal mix of collations (latin2_general_ci,IMPLICIT) and
(latin1_swedish_ci,COERCIBLE) for operation '='

The appropriate values when using mysqladmin to check the variables
are as follows:

| character_set_client            | latin2
| character_set_connection        | latin2
| character_set_database          | latin2
| character_set_results           | latin2
| character_set_server            | latin2
| collation_connection            | latin2_general_ci
| collation_database              | latin2_general_ci
| collation_server                | latin2_general_ci

All the tables are converted to the latin2 charset, all the relevant
columns have "latin2_general_ci" set as the default collation.

The following entry in the my.cnf file also doesn't help:

character_set   = latin2

The webserver is set to use ISO-8859-2 (latin2) as the base charset:
AddDefaultCharset iso-8859-2

The appropriate php packages are version 4.3.10-1 from dotdeb.org.
The libmysqlclient package is version 4.1.7-1 from the same source.
Same goes for the mysql-server package.

This problem has appeared only when migrating from PHP 4.3.9 to
4.3.10, before that everything worked fine. I have partially remedied
the problem by putting the 3 queries:

set names latin2;
set character set latin2;
set collation_connection='latin2_general_ci';

after the initializing code of every MySQL connection I make. However,
since I host multiple sites on the server and possibly have multiple
PHP applications that use SQL client connections, I cannot use this as
a final solution. Downgrading is also not a good option because I
cannot find the old .deb packages anywhere (besides, it might be
caused by some bizarre change done to the configuration file by the
4.3.10 preinstall script, but I've done a quite thorough search
through the config files and found naught). Do you perhaps know how
would I be able to 'force' the PHP MySQL client to accept the latin2
encoding as default?

Piotr Wilkin
[EMAIL PROTECTED]       PGP key: http://pwl.yz.pl/pwlpgp.txt

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to