Hello,

first, sorry for a little bit off topic.

We plan a database and need also a translation from some text.
We have textfields in multiple tables. Some with one, two words, some
with more text.

What is "best practice" for translations into different languages, where
the languages are not fixed, and some text never would be translated.

I know solutions like copy the whole database to database_de, database_fr
and so on.
An other solution is same practice, but with tables like table_de,
table_fr and so on.
The last one, I know is to make a translation table where all textfields
are inside and linked to the tablefield.

For example:
tblid | textid
1 | 100

langid | textid | lang | text
1 | 100 | en | Hello
2 | 100 | de | Hallo

Any other ideas?

Thanks
Andreas
--
Kraftl EDV - Dienstleistungen
Linuxschulungen, Weblösungen, Linuxlösungen
http://www.kraftl.at

Andreas Kraftl <andreas.kraftl (AT) kraftl (DOT) at> wrote:
I think that this is a good way to do it.
You can have a default language (say, langid 1).

Make sure to have a good index (e.g., primary key on textid and langid,
in that order).

Yours,
Laurenz Albe

Andreas Kraftl <andreas.kraftl (AT) kraftl (DOT) at> wrote:
I think that this is a good way to do it.
You can have a default language (say, langid 1).

Make sure to have a good index (e.g., primary key on textid and langid,
in that order).

Yours,
Laurenz Albe

Andreas Kraftl <andreas.kraftl (AT) kraftl (DOT) at> wrote:
I think that this is a good way to do it.
You can have a default language (say, langid 1).

Make sure to have a good index (e.g., primary key on textid and langid,
in that order).

Yours,
Laurenz Albe

Andreas Kraftl <andreas.kraftl (AT) kraftl (DOT) at> wrote:
I think that this is a good way to do it.
You can have a default language (say, langid 1).

Make sure to have a good index (e.g., primary key on textid and langid,
in that order).

Yours,
Laurenz Albe

Andreas Kraftl <andreas.kraftl (AT) kraftl (DOT) at> wrote:
I think that this is a good way to do it.
You can have a default language (say, langid 1).

Make sure to have a good index (e.g., primary key on textid and langid,
in that order).

Yours,
Laurenz Albe

Andreas Kraftl <andreas.kraftl (AT) kraftl (DOT) at> wrote:
I think that this is a good way to do it.
You can have a default language (say, langid 1).

Make sure to have a good index (e.g., primary key on textid and langid,
in that order).

Yours,
Laurenz Albe

Andreas Kraftl <andreas.kraftl (AT) kraftl (DOT) at> wrote:
I think that this is a good way to do it.
You can have a default language (say, langid 1).

Make sure to have a good index (e.g., primary key on textid and langid,
in that order).

Yours,
Laurenz Albe

Andreas Kraftl <andreas.kraftl (AT) kraftl (DOT) at> wrote:
I think that this is a good way to do it.
You can have a default language (say, langid 1).

Make sure to have a good index (e.g., primary key on textid and langid,
in that order).

Yours,
Laurenz Albe