Databases
StackOverflow2013
Postsdbo
POStoring content in multiple languages? E.g. English, French, German
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POStoring content in multiple languages? E.g. English, French, German
    primarykey
    data
    text
    <p>How should I store (and present) the text on a website intended for worldwide use, with several languages? The content is mostly in the form of 500+ word articles, although I will need to translate tiny snippets of text on each page too (such as "print this article" or "back to menu").</p> <p>I know there are several CMS packages that handle multiple languages, but I have to integrate with our existing ASP systems too, so I am ignoring such solutions.</p> <p>One concern I have is that Google should be able to find the pages, even for foreign users. I am less concerned about issues with processing dates and currencies.</p> <p>I worry that, left to my own devices, I will invent a way of doing this which work, but eventually lead to disaster! I want to know what professional solutions you have actually used on real projects, not untried ideas! Thanks very much.</p> <hr> <p>I looked at RESX files, but felt they were unsuitable for all but the most trivial translation solutions (I will elaborate if anyone wants to know).</p> <p>Google will help me with translating the text, but not storing/presenting it.</p> <p>Has anyone worked on a multi-language project that relied on their own code for presentation?</p> <hr> <p>Any thoughts on serving up content in the following ways, and which is best?</p> <ul> <li><a href="http://www.website.com/text/view.asp?id=12345&amp;lang=fr" rel="nofollow noreferrer">http://www.website.com/text/view.asp?id=12345&amp;lang=fr</a></li> <li><a href="http://www.website.com/text/12345/bonjour_mes_amis.htm" rel="nofollow noreferrer">http://www.website.com/text/12345/bonjour_mes_amis.htm</a></li> <li><a href="http://fr.website.com/text/12345" rel="nofollow noreferrer">http://fr.website.com/text/12345</a></li> </ul> <p>(these are not real URLs, i was just showing examples)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJasonMArcher
    1. USMagnus Smith
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POStoring content in multiple languages? E.g. English, French, German
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POStoring content in multiple languages? E.g. English, French, German
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POStoring content in multiple languages? E.g. English, French, German
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload