Re[2]: [PHP-DB] 'Illegal mix of collations' with PHP 4.3.10 and MySQL 4.1.7

[cut] DG> I've got the same problem with PHP 5.0.2 and MySQL 4.1.8. I asked this DG> question many times on different mailing lists but still haven't got DG> satisfactory answer... That's the problem, I've reviewed different mailing lists as well but saw no reply... all problems that were presente

RE: [PHP-DB] 'Illegal mix of collations' with PHP 4.3.10 and MySQL 4.1.7

Hello Piotr, > -Original Message- > From: Piotr Wilkin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 28, 2004 5:46 AM > To: [email protected] > Subject: [PHP-DB] 'Illegal mix of collations' with PHP 4.3.10 and MySQL > 4.1.7 > > I have notic

[PHP-DB] 'Illegal mix of collations' with PHP 4.3.10 and MySQL 4.1.7

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 fol