topic Re: How to modify database to UTF-8? in Alfresco Archive

How to modify database to UTF-8?

jilingshu — Sat, 20 Nov 2010 02:53:46 GMT

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,

Re: How to modify database to UTF-8?

nramdoo — Fri, 04 Mar 2011 10:22:52 GMT

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

Re: How to modify database to UTF-8?

stegbth — Thu, 23 Jun 2011 15:53:30 GMT

hi,

this string is default in 3.4d
but how should the data from a previous version get converted?

best regards
thomas

Re: How to modify database to UTF-8?

mrogers — Thu, 23 Jun 2011 16:18:07 GMT

http://forums.alfresco.com/en/viewtopic.php?f=8&t=38884