Hello!

How do you best localize large amounts of text stored in a DB?

We need to support ~10 languages and more to come. Currently, bad
practice is to put new columns into tables where text needs to be
localized in a new language.

So if an entity type has something like a name and description (in
english first), it will get name_ger and description_ger for German.
This is repeated for every language and results in very large tables.

Also, when adding new attributes, each existing language will need one
more column just for localized text on per table basis.

Is there any good resource on the web or a book where I can learn how to
do it better? To me, this sounds like a distributed database of which I
have no clue - yet...

Is there any standard way? We can't go the Babelfish or any other
translation way...

Thanks for helping!

Karsten