How to internationalize your site with Wordpress (qTranslate) (3)

The post “How to internationalize your site with WordPress (qTranslate), "How to internationalize your site with WordPress (qTranslate)(2)" was written before.

In previous post, I described any works to install of qTranslate, and to edit of translation,and Note.
Here, I will describe how qTranslate uses the data base and table.

Where does qTranslate preserve information on the translation?

In General, Internationalization (Multi Language) plug-in is two types.
A type is plugin that automatically translate. Another is plugin that edit translation.
The first type translates automatically by using web api like Google tranlator api, and even displays it.
So, you will not be able to edit information of transration.

The second type displays translation information by preserving information that you translated in the data base.
So, you will translate all posts yourself.

qTranslate is the second type.
Where does qTranslate preserve information on the translation?

The answer is one of the following three tables.

• wp2_blog_off_posts: post
• wp2_blog_off_terms: categories, tags
• wp2_blog_off_options: blog options (title, description ,etc,.)

All tables have already existed before qTranslate installs it.

wp2_blog_off_posts: example set of post

wp2_blog_off_posts: This post has been set as follows.

[wp2_blog_off_posts. post_title: title of post]
<!–: ja -> Japanese Title <!–:–>
<!–: en -> English Title <!–:–>

[wp2_blog_off_posts. post_content: content of post]
<!–: ja -> Japanese Description <!–:–>
<!–: en -> English Description <!–:–>
<! – more ->
<!–: ja -> Japanese Content <!–:–>
<!–: en -> English Content <!–:–>

wp2_blog_off_terms: example set of categories, tags

It is saved characters that serialized like a following php code.

Array
(
    [WordPress] => Array
        (
            [ja] => ワードプレス
            [en] => WordPress
        )
);

wp2_blog_off_options: example set of blog options (title, description ,etc,.)

The option 'blogname' has been set as follows.

[:Ja]Blog title of Japanese [:en]Blog Title of English

In other words, if qTranslate does not provide a text-area for translation such as a setting manage windows, you can set information of translation like above example.

You might also like:

• How to internationalize your site with WordPress (qTranslate)
• How to internationalize your site with WordPress (qTranslate)(2)
• Redirect Loop by qTranslate on WordPress 3.0
• Thunderbird 3 release is now official
• Create a Sitemap in WordPress

Leave a Reply