topic Re: Chinese simplified in Alfresco Archive

Chinese simplified

chys — Thu, 23 Aug 2007 02:53:49 GMT

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 cha

Re: Chinese simplified

charbel — Thu, 23 Aug 2007 10:18:10 GMT

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 .

Re: Chinese simplified

kevinr — Mon, 03 Sep 2007 10:53:22 GMT

Are you using a utf-8 database in mysql?

Thanks,

Kevin

Re: Chinese simplified

charbel — Thu, 13 Sep 2007 14:50:26 GMT

Hi,

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

Regards.
Charbel

Re: Chinese simplified

joel18 — Thu, 17 Apr 2008 09:22:38 GMT

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:

Re: Chinese simplified

jtsaitw — Fri, 18 Apr 2008 01:51:05 GMT

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

Re: Chinese simplified

joel18 — Fri, 18 Apr 2008 01:55:13 GMT

Hi jtsaitw ,

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

Best Regards.

Re: Chinese simplified

kayan — Mon, 22 Dec 2008 22:25:46 GMT

Hi jtsaitw,

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

Thanks
Kayan

Re: Chinese simplified

vinaxwater — Fri, 13 Feb 2009 08:23:23 GMT

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

Thanks

Re: Chinese simplified

vinaxwater — Mon, 16 Feb 2009 04:27:20 GMT

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

Regards.

Re: Chinese simplified

jtsaitw — Mon, 16 Feb 2009 07:48:20 GMT

Hi,

I have no problem with Chinese File/Space name, but when I use Alfresco online editor to "Create Content" for a html/plainText file; the Chinese characters will be changed to ??????????, after I saved the file.

anyone have idea of this?

jtsaitw