AW: [opencms-dev] Illegal mix of collations error

[Thomas Weckert]

Hi, that param gets set by the key mysql.constr.params in
webapp/setup/database/mysql/database.properties, which contains a set of
predefined key/value pair settings per db server.

Hth,
Thomas Weckert
Alkacon Software - The OpenCms Experts
http://www.alkacon.com 


> -----Ursprüngliche Nachricht-----
> Von: opencms-dev-admin at opencms.org 
> [mailto:opencms-dev-admin at opencms.org] Im Auftrag von 
> leightonbrown at excite.com
> Gesendet: Mittwoch, 30. Juni 2004 23:33
> An: opencms-dev at opencms.org
> Betreff: RE: [opencms-dev] Illegal mix of collations error
> 
> 
> 
> Hi,
> 
> does anyone know where in source code the opencms.properties 
> key : 
> db.pool.default.jdbcUrl.params=?useUnicode\=true&characterEnco
> ding\=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(CmsWork
> flowDriver.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>Thi
> s 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! 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, 
> please visit http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
>