title: How to store multilingual data?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/316780/schema-for-a-multilanguage-database">Schema for a multilanguage database</a>  </p>
  </blockquote>
  
  
  
  <p>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:</p>
  
  <ol>
  <li>separate columns in the table for each language (like title_en, title_fr)</li>
  <li>separate tables for each language (like pages_en, pages_fr)</li>
  <li>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)</li>
  <li>having non-multilingual data in one table for example pages and translations in one table per language (pages_en, pages_fr)</li>
  <li>other?</li>
  </ol>