Topics

1

Developers / Chinese Translation SOLVED !!!!

« 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
  skip-character-set-client-handshake
-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.

Regards,
Samir