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

Fri Jul 2 18:47:01 CEST 2004

Hi,

I changed the key's value to ?useUnicode\=true&characterEncoding\=ISO-8859-1 which allowed me to complete the steps to import the workspace. However my /sites/default/resource folder is now empty for both online and offline projects. I don't think this is correct. I remember seeing so error about locales. Is there an installation log ? and do we require unicode to install the resources ?

Leighton

 --- On Thu 07/01, Thomas Weckert < t.weckert at alkacon.com > wrote:
From: Thomas Weckert [mailto: t.weckert at alkacon.com]
To: opencms-dev at opencms.org
Date: Thu, 1 Jul 2004 12:24:12 +0200
Subject: AW: [opencms-dev] Illegal mix of collations error

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 > > 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(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] 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! _______________________________________________ Thi > s 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 > > _______________________________________________ > 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 > > _______________________________________________ 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

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