I need to develop a multilingual web site and I am looking for the best way.
There are few issues:

1. Storing multilingual data in a database. Possible solutions:
a. many tables, one per each supported language, e.g. table_en, table_de.
b. one table having many columns with translations, e.g. (id, date, text_en,
text_de)

Use MySQL 4.1 as a back-end.

2. Multilingual HTML templates, possible solutions:

a. one generic template for everything, one per each language, like
contents_english.template.html, contents_danish.template.html

b. many localized templates for each page, e.g news_en.tpl.html,
news_de.tpl.html

3. Storing current language variable, possible solutions:
a. inside the URL like /en/news/
b. using cookies
c. using sessions

Web server is Apache2 + mod_rewrite with PHP5

What are advantage and disadvantage for each solution? What are other possible solutions for the above issues?

__________________
Venkat
knowledge is Power

what is meant by MultiLingual WebSite?

__________________
Thanks & Regards
Sabari...

Different language supporting of websites....


I think in PHP we need to redisgn the whole structure of PHP pages for multilingual support

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)