Iīm building a database for my website, and I have around 30 languages to translate it to.
I build a table for languages, and I want to relate content to it.
language_short (content example : EN)
language_short (related, EN or CRO for croatian, depending on the row)
logout (example : logout, "odlogiraj se" in croatian)
So you see the problem?
How do I structure so many information without having to make so many collumns? How do I make it more simple, while I still structure the content into a logical database?
When I develop multi lingual applications I look at this in a different way. I use a concept of labels. So you start off with a label called FIELD. In english we would translate that into Field, in Spanish Campo, in French champs ... So my table structure is