[3Nex]

Hello,

I'm wondering what would be the best database structure for my Articles modul to have multi language support. Does it involve more then one table or not..

Currently i have it solved with the `language_group` column which, if the article is on other language then the original, has the same value as `article_id` of the original article. Otherwise it's NULL. So, the first article has the `article_id` = 1, `language_group` = NULL (and `lang` = "en") and is in english. Then if you were to translate it to spanish and save it, it would become a new row inside the same table with `article_id` = 2 (of course), and `language_group` = 1 (and `lang` = "es").

Is this okay, what are the downsides, do you have any better ideas, how did you do it, how do other people do it?

Thanks.

[wirehopper]

You might want to check out The CMS Matrix - cmsmatrix.org - The Content Management Comparison Tool.

[3Nex]

I honestly can't see how that helps me. Am i missing something or did you not read my whole post?

[wirehopper]

I did read your post.

There are two reasons I offered the link. First, if you need a multi-lingual CMS and you don't have one, or you're in the middle of building one, you may want to choose an existing system. The second reason is that you could identify existing multi-lingual CMSs and look at the code to see how they implemented it, then choose the approach you like best.