Database With More than one Language!

[kiguhu]

Hi guys! I once come with one problem. I wanted my software to have more than one language in its interface then I have noticed that I have to start with constructing the database which will accommodate data of more than 1 language there after I design the codes! May one who know tell me how to go about????!

[johanafm]

Solution 1.
A table, "table", containing text that should exist in multiple languages should have that text replaced by a text_id, and the text moved to "table_text" which should contain text_id, language_id, text, primary key(text_id, language_id).

Solution 2.
Replace text with text_id as above, but keep all texts in one single table. When a user comes to your site, select all texts in this user's default language (use geoip, or default ot english or ...), then stuff them into session variables, and during the whole session you will not have to keep JOINING data tables with language tables.

Solution 3.
Keep your texts outside your database, and use a template engine which supports multiple languages, such as smarty.