[Fwd: New to Roller - JDBCExceptionReporter:logExceptions - Illegal mix of collations]

[Bhaskar Chikpea <bh...@chikpea.com>]

Re: [Fwd: New to Roller - JDBCExceptionReporter:logExceptions - Illegal mix of collations]

[Sutra Zhou <zh...@gmail.com>]

Set the same collation in your jdbc url as the database's.

17 Jan 2007 09:43:54 +0530, Bhaskar Chikpea <bh...@chikpea.com>:
>
>
>
>
>
> ---------- 已转发邮件 ----------
> From: Bhaskar Chikpea <bh...@chikpea.com>
> To: roller-user-help@incubator.apache.org
> 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
>
>
>