Set the same collation in your jdbc url as the database's.
17 Jan 2007 09:43:54 +0530, Bhaskar Chikpea <[EMAIL PROTECTED]>:
---------- 已转发邮件 ----------
From: Bhaskar Chikpea <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: 17 Jan 2007 09:25:14 +0530
Subject: New to Roller - JDBCExceptionReporter:logExceptions - Illegal mix
of collations
Hi,
I tried to install Roller, followed the install document, the site comes
up but when I tried to create user I got error -
WARN 2007-01-16 22:57:25,492 JDBCExceptionReporter:logExceptions - SQL
Error: 1267, SQLState: HY000
ERROR 2007-01-16 22:57:25,494 JDBCExceptionReporter:logExceptions -
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='
ERROR 2007-01-16 22:57:25,501 UserNewAction:add - ERROR in addUser
org.apache.roller.RollerException
at
org.apache.roller.business.hibernate.HibernateUserManagerImpl.getUserByUserName
(HibernateUserManagerImpl.java:543) at
org.apache.roller.business.hibernate.HibernateUserManagerImpl.getUserByUserName
(HibernateUserManagerImpl.java:491) at
org.apache.roller.business.hibernate.HibernateUserManagerImpl.addUser(
HibernateUserManagerImpl.java:231)
at org.apache.roller.ui.core.struts.actions.UserNewAction.add(
UserNewAction.java:173)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
Any help will be appreciated.
Thanks
Bhaskar Roy
www.chikpea.com
