How to store multilingual data?

Possible Duplicate:
Schema for a multilanguage database

I am building a very busy web application which has multilingual data. All this data is stored in a MySQL database. What is the best way to store this data? I have a few guesses though:

separate columns in the table for each language (like title_en, title_fr)

separate tables for each language (like pages_en, pages_fr)

cross table for translations (having an id in the pages table and having this linked id in a translation table where there are multiple columns like trans_en, trans_fr)

having non-multilingual data in one table for example pages and translations in one table per language (pages_en, pages_fr)

other?

---

If I had to make a site multilingual, then I would design the db as follows:

Every page in the application can have multiple languages. You only have to filter on the language id to get the desired language for the page.

链接地址: http://www.djcxy.com/p/37466.html

上一篇: 多语言设计数据库。 双重独特的关键引用外键

下一篇: 如何存储多语言数据？