cancel
Showing results for 
Search instead for 
Did you mean: 

Garbage character when view document which contains Chinese

wengm
Champ in-the-making
Champ in-the-making
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!
6 REPLIES 6

mitpatoliya
Star Collaborator
Star Collaborator
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.

wengm
Champ in-the-making
Champ in-the-making
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.

mitpatoliya
Star Collaborator
Star Collaborator
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.

wengm
Champ in-the-making
Champ in-the-making
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.

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

wengm
Champ in-the-making
Champ in-the-making
Could you please describe your solution in more details? Thanks!