[opencms-dev] Illegal mix of collations error

[leightonbrown at excite.com]

Hi,

does anyone know where in source code the opencms.properties key :
db.pool.default.jdbcUrl.params=?useUnicode\=true&characterEncoding\=UTF-8
gets set ?

Leighton



 --- On Wed 06/30, leightonbrown at excite.com < leightonbrown at excite.com > wrote:
From: leightonbrown at excite.com [mailto: leightonbrown at excite.com]
To: opencms-dev at opencms.org
Date: Wed, 30 Jun 2004 08:10:37 -0400 (EDT)
Subject: [opencms-dev] Illegal mix of collations error

<br>Hi,<br><br>I'm using <br>opencms version: pre5.3.6dev Ix (from CVS)<br>tomcat : 5.0.25<br>mysql : 5.0.0<br>linux (kernel) : 2.6.7<br><br>I'm not able to import the workspace on initial setup. I get errors like - <br>103:	>>Root cause was: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='<br>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]<br><br>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 <br>mysql-connector-java-3.1.2-alpha-bin.jar<br><br>without success.<br><br>Any ideas ?<br><br>Leighton<br><br><br><br><br>_______________________________________________<br>Join Excite! - http://www.excite.com<br>The most personalized portal on the Web!<br>_______________________________________________<br>This mail is send to you from the opencms-dev mailing list<br>To change your list options, or to unsubscribe from the list, please visit<br>http://mail.opencms.org/mailman/listinfo/opencms-dev<br>

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