[opencms-dev] Illegal mix of collations error

[leightonbrown at excite.com]

Hi,

I'm using 
opencms version: pre5.3.6dev Ix (from CVS)
tomcat : 5.0.25
mysql : 5.0.0
linux (kernel) : 2.6.7

I'm not able to import the workspace on initial setup. I get errors like - 
103:	>>Root cause was: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
102:	>>org.opencms.main.CmsException: [org.opencms.db.mysql.CmsWorkflowDriver] where: org.opencms.db.generic.CmsWorkflowDriver.writeTaskType(CmsWorkflowDriver.java:823), why: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [Code 4 - Sql exception]

I've tried the mysql connector which came with opencms. ( mysql-connector-java-3.0.11-stable-bin.jar ), I've also tried the mysql-connector-java-3.0.14-production-bin.jar ,  mysql-connector-java-3.1.nightly-20040630-bin.jar , and 
mysql-connector-java-3.1.2-alpha-bin.jar

without success.

Any ideas ?

Leighton




_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!