Setting up your WordPress platform for Chinese language for your Blog

By
malaysiainsurance
 – November 20, 2009Posted in: Grapevine, Open Source
Setting up your WordPress platform for Chinese language for your Blog
I came across this blogsite: http://www.kpebiz.com
It has some write-up in regards setting up the wordpress for chinese language blogging…. Looks good and sounds logical. Perhaps this is one way we can work on a Chinese WordPress blog to enhance eCommerce among insurance consumers.
One fork rule the road....

One fork rule the road....

Well, I have yet to find the time to try this out….. but if you do, please tell me if this is workable.

I am sure there are many people setting up their blog using English as 1st language. However, sometimes you might want to write in Chinese as well. The wordpress default will give you stupid question marks after clicking the save or publish button.

I found that there is a way you can configure the blog for using both english & chinese. Here’s the step by step guide that I went through.

How to Setup WordPress for Chinese Language

1. Open phpMyAdmin in CPanel

In order to type chinese on your blog, you will need to change some settings inside the SQL database. Firstly, you will need to login to your CPanel, then open phpMyAdmin as followed:

phpMyAdmin phpMyAdmin 

2. Select Database & Table of Your Blog

After launching the phpMyAdmin screen, you will need to select the database of your blog on the pull down menu. Once you have selected the database, you will be able to see all the existing tables of the database showing right below the pull down menu.

How to Select Database Table in phpMyAdmin How to Select Database Table in phpMyAdmin 

3. Set Collation to utf8_unicode_ci

Click on the database table, you will see the table structure appearing on the right hand side of the screen. In order to store chinese in the database, you need to change the collation setting from latin1_swedish_ci to utf8_unicode_ci.

To change the collation setting, click on the pencil button and you will be a pop up window appearing. Scroll on the pull down menu to select utf8_unicode_ci and save the setting.

You need to go through this steps for all the fields that has existing setting of latin1_swedish_ci. You also need to repeat this step for all tables in the database as well.

Set utf8_unicode in SQL Database Set utf8_unicode in SQL Database 

You are Done… Good Luck to You!

After completing the above mentioned steps, you should be able to type and store chinese text (??? like I do.  Though I have never tested this on other asian language, but I suppose it should work as well. Maybe you can share with me if you do have some success on that. All the best to you!

contact me
Highlight any portion you want: Use a Highlighter on this page
number of view: 358
Tags: ,

About the Author

The Author has spent more than 23 years engaging in insurance related works and research. Head of Underwriting & Reinsurance, and is currently involves with R&D of relevance to the development of eCommerce for the Non-Life insurance industry.