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?