[30 Apr 2004 2:24pm] Oleg Ivanov
Description:After migrating from 3.0.9 driver to 3.1.1alpha some SELECTS could not beexecuted due to error: "Illegal mix of collations.."If it is a bug it must be solved, because jdbc driver are COMPLETELY broken. Ifit is a "feature", it must be documented. It is not a good practice whenswitching a jdbc drivers goes application unusable.How to repeat:Simple query:rset = stmt.executeQuery("SELECT A, B, C FROM TABS WHEREEMAIL=LOWER(’"+user+"’)");return an exception:General error message from server: "Illegal mix of collations(cp1251_bulgarian_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation’=’"The same error is reported in list http://lists.mysql.com/java/7373Suggested fix:
[30 Apr 2004 3:23pm] Mark Matthews
This is a duplicate of #2177.The error is caused by changes needed to support MySQL-4.1, which were made whenthe charsets functionality in MySQL-4.1 was still in flux.You will need to download the latest nightly snapshot of Connector/J 3.1 fromhttp://downloads.mysql.com/snapshots.php to see the fix, or wait for the releaseof Connector/J 3.1.2.