AnsweredAssumed Answered

How to modify database to UTF-8?

Question asked by jilingshu on Nov 20, 2010
Latest reply on Jun 23, 2011 by mrogers
hi there,
I found that the table in database is in latin1 encoding. I wanna modify it to UTF8 to support CJK characters. If I modify the tables to UTF8, Alfresco would not run and the log said:
— Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred while applying a parameter map.
— Check the alfresco.node.select_ChildAssocsOfParent-InlineParameterMap.
— Check the statement (query failed).
— Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
and so on.
Could you tell me how to fix it? thx!

Outcomes