Hello,

I’m currently writing an application that will be used in more than one language and would like to get some advice concerning a good way to handle multilanguage entries in the database schema.

See the attached images:

version1.jpg from here

and version2.jpg, my own design.

Both ways have their weaknesses/benefits…
In both approaches the language dependent data is factored out into separate tables - in version1 there is a table for every entity that holds the translations and in version2 one table that holds all strings and one that holds all translations.

Any experience with something like this?
What would you recommend?

PS: I have asked this question also in CodeIgniter Forums