LinuxMCE Forums

General => Developers => Topic started by: samir on May 16, 2009, 08:59:40 pm

Title: Chinese Translation SOLVED !!!!
Post by: samir on May 16, 2009, 08:59:40 pm
Hi, I am Samir.I have been working on creating new skin for my hotel project. It is now 80% complete. I have solved the problem for displaying chinese characters in linuxmce. Here is what I did.

-first backup the databases pluto_main and pluto media.
-now edit the sql file for pluto_main and pluto_media backup and replace all latin1 with utf8.
-download arialuni.ttf and copy it to /usr/share/fonts/truetype/msttcore
-backup verdana.ttf and Verdana.ttf to new location
-rename arialuni.ttf to verdana.ttf and Verdana.ttf
-drop database pluto_main and pluto_media
-convert the pluto_main and pluto_media backup sql to utf8 format with UTFconverter or recode tool
-create database pluto_main and pluto_media with characterset =utf8 and collation = utf8_general_ci
-backup my.cnf from /etc/mysql
-edit my.cnf and add in mysqld section

  collation_server =utf8_general_ci
  character_set_server = utf8
-save my.cnf
-dump the backup database back to mysql
-restart the pc
all was working as I expected.

Hope this will help guys who are doing translations to another language as well.


Title: Re: Chinese Translation SOLVED !!!!
Post by: dlewis on May 17, 2009, 03:05:09 pm
Please submit a ticket in Trac.