topic Garbage character when view document which contains Chinese in Alfresco Archive

Garbage character when view document which contains Chinese

wengm — Mon, 09 Apr 2012 09:58:59 GMT

I uploaded on document on Alfresco Share site's Document Library. Then, I click the document title to preview its content. In preview page, all Chinese characters are displayed as "?".Anybody can help me out of this? Thanks!

Re: Garbage character when view document which contains Chinese

mitpatoliya — Mon, 09 Apr 2012 10:38:05 GMT

You need to configure you database to support those characters.
Check out how to add support for UTF-8 and UTF-16 character in your database.
Just do that and restart the server.

Re: Garbage character when view document which contains Chinese

wengm — Thu, 19 Apr 2012 08:30:34 GMT

You need to configure you database to support those characters.
Check out how to add support for UTF-8 and UTF-16 character in your database.
Just do that and restart the server.

Had you encountered the same issue? I used postgresql and create the database with below statement:

create database alfresco WITH ENCODING 'UTF8';‍

However, the Chinese character isn't displayed as expected yet.

Re: Garbage character when view document which contains Chinese

mitpatoliya — Thu, 19 Apr 2012 09:51:18 GMT

Yes, I was using the mysql db where we need to do changed in some configuration file and it works fine.
I am sure that was UTF-16 or UTF-8.
The other thing is your JSP files should also have some tag which specifies the support for the same encoding.

Re: Garbage character when view document which contains Chinese

wengm — Fri, 20 Apr 2012 02:51:58 GMT

Yes, I was using the mysql db where we need to do changed in some configuration file and it works fine.
I am sure that was UTF-16 or UTF-8.
The other thing is your JSP files should also have some tag which specifies the support for the same encoding.

I mean if you had encountered the issue in using alfresco community edition. How did you fix it? Just adjust encoding of the database?

In my understanding, this isn't caused by database encoding but the document converter's relevant configuration.

Re: Garbage character when view document which contains Chinese

mitpatoliya — Mon, 23 Apr 2012 09:28:51 GMT

Yes, I have encountered this problem and as I have mentioned by doing those two changes it works for me.

Re: Garbage character when view document which contains Chinese

wengm — Thu, 03 May 2012 08:36:05 GMT

Could you please describe your solution in more details? Thanks!