Recommendation for separating bilingual contents

rubyonrails-talk
1

Hi,

Is there any recommended way to separate the contents for different languages e.g. English and French? Especially, when the content is added by the user separately in English and French for the same one topic, how do you recommend to structure models and store them in database? I want to keep the search for the content simple also.

I have been doing it in my own way. But I think it's time to follow the best practices if there is any.

Thank you.

2

To be able to help you should be more specific about what the content is and how it is differ in different languages.

3

Hi,

Thank you for your reply.

The content is written by administration users both in English and French. So they are not direct translation from each other. It is associated with an effective date.

I don't want to duplicate the effective date for English content and French content because it is identical. But I don't want to use joins much because I don't want to deal with a problem with search and tagging capability.

So I would like to know if there are best practices in this matter.

Thank you. Tadatoshi

4

Best practices are guidelines to adequate solutions and as such can vary from one particular issue to another. I'm not familiar with any of them concerning the multilingual issues even I have build some multi language applications. My rule of thumb is to have as less as possible redundant informations that are not language dependent. In you case you can split content to two parts. One that is language dependent and the common one. If the content must be present even if there is non in selected language the two strategies can be applied: show content in default language or show the error message.

You can look at some rails plug-ins like globalite (http://github.com/ mattetti/globalite/tree/master) or Gloc (http://rubyforge.org/projects/ gloc/) and combine it with your own solution.

The internationalization plug-ins list can be find at http://agilewebdevelopment.com/plugins/category/8

5

Thank you, Dejan,

I agree with your rule of thumb. I will keep that in mind.

Thank you for your advice.

Sincerely, Tadatoshi