How to modify database to UTF-8?

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

jilingshu

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!

nramdoo

hello,
I don't if this will help, you may check that you have the following lines in your alfresco-global.properties file.

# MySQL connection
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=yes&characterEncoding=UTF-8"

This part "?useUnicode=yes&characterEncoding=UTF-8" concerns internationalisation.
bye