topic Re: Chinese Period in Alfresco Archive

Chinese Period

jriker1 — Fri, 28 Aug 2009 14:57:54 GMT

I inquired about chinese character based files in CIFS which I didn't hear back on but finding it's a bigger issue. If I go thru Share and upload a chinese document into Alfresco it comes back with all question marks for the document name. The MySQL DB itself is UTF-8 so is there a big issue with

Re: Chinese Period

zaizi — Fri, 28 Aug 2009 15:28:17 GMT

Are you able to share a copy of this document?

Re: Chinese Period

mikeh — Fri, 28 Aug 2009 16:33:22 GMT

It's likely a configuration issue. If you've built from HEAD, are you sure you compiled with UTF-8 on?

Also make sure you've got Tomcat configured to use UTF-8 URIs and double-check the database is actually using UTF-8. Do you still see the issue if you upload to the Explorer web client?

This is HEAD running just now with some of my test content :wink:
[img]http://img.skitch.com/20090828-d1ns2gr2bit8t76kcammc56ndx.png[/img]

Mike

Re: Chinese Period

jriker1 — Mon, 31 Aug 2009 20:35:25 GMT

Thanks for the reply. Reconfiguring Eclipse didn't help. Added URIEncoding="UTF-8" to the 8080 connector but no joy there either. DB is indeed UTF-8. Also tried in /alfresco and it did the same thing once saved.

Thanks.

Re: Chinese Period

jriker1 — Tue, 01 Sep 2009 13:56:26 GMT

The correct answer was to append to the db.url in the alfresco-global.properties file:

?useUnicode=true&characterEncoding=utf-8