Chinese simplified

[chys]

1 I have installed  alfresco-community-tomcat2.1 with HSQL in windows XP.But when I login it using English ,it still has some Chinese  characters. Why this happer?.

2 I also installed alfresco-community-tomcat2.1 with mysql in windows XP.But when I login it using any language,the original Chinese characters all became ?.

Who can give me some suggestion?Thank you very much!

[charbel]

2 I also installed alfresco-community-tomcat2.1 with mysql in windows XP.But when I login it using any language,the original Chinese characters all became ?.

Hi chys,

I think it is a unicode problem.
I used ti have same ??? when translating to arabic and then I used native2ascii converter and used iso-9-855-1

Good luck .

[kevinr]

Are you using a utf-8 database in mysql?

Thanks,

Kevin

[charbel]

Hi,

I am not using THE HSQL.
I used an utf8 converter worked fine.

Regards.
Charbel

[joel18]

Hi,

   I also meet this unicode problems as Chys's.

Can somebody tell me how to change the unicode of Alfresco?  I have no idea how we change the unicode of Alfresco. Thank you very much. :cry:

[jtsaitw]

Hi joel18,

I did have the Chinese filename  problem before , it show as ???????.doc … , but now I have fixed it with utf8 mysql db.
I am using alfresco-community 2.9B with  mysql  database ( with UTF8  character set ), and Chinese space/file name  display fine.

The way I did :
0.  ==>  suppose you have alfresco system run ok, the only problem is the Chinese fileName and Chinese spaceName ??????
1.  Install  "phpmyadmin"  mysql tool will be used.
2.  Stop Alfresco service ==>  #/etc/init.d/alfresco stop
3.  Use phpmyadmin  ==> export the "alfresco"  mysql database to   "alfresco-serverName-date.sql"
4.  use text editor ==>  edit  "alfresco-serverName-date.sql" 
4.1       change   all  "CHARSET=latin"     ==> into  "CHARSET=utf8"
5.  use phpmyadmin  ==> drop mysql database "alfresco"
6.  use phpmyadmin  ==>  recreate  "alfresco" database with utf8 collation
6.1       on phpmyadmin  ==> a.  select mysql connection collation :  "utf8_general_ci"  
                                              b.   create new database :    "alfresco"    Collation:  "utf8_general_ci"
7.  import alfresco database ==>   # mysql -p alfresco  <  /pathTo/alfresco-serverName-date.sql
8.  use phpmyadmin ==>  check if the "alfresco" database have 65 tables
9.  start alfresco service ==>  # /etc/init.d/alfresco start
done.

Now you can upload new ChineseFileName.doc , and it should display Chinese file name fine.
The old  ????.doc file is still there, and I can't delete it.
==> if any one know how to delete the ???? files, please help us.

jtsaitw

[joel18]

Hi jtsaitw ,

    Thank you very much. I will try it according to your suggestions.

Best Regards.

[kayan]

Hi jtsaitw,

You can rename this "????.doc" files and delete them.

Thanks
Kayan

[vinaxwater]

It's not effect for me with MYSQL. Help me!

Thanks

[vinaxwater]

I haved got it. Please view http://forums.alfresco.com/en/viewtopic.php?f=14&t=16964

Regards.