multilanguage - Multi-language support without altering database structure -


i have question regarding support languages on website.

what best way structure database, while using multiple languages? example, while creating database schema has agenda table, news table , products table. of these components have description , title.

the structure be:

  • agenda(id, title, description)
  • news(id, title, description)
  • products(id, title, description)

normally, create languages table. every aforementioned table column; language_id.

that means every translation of record gets inserted again, using different id. advantage of method can add multiple languages , without altering database (you can add new row in newly created language table, , insert corresponding language_id in news/agenda/products table).

know aware of fact cumbersome. rows have same content - in different translation - have no way of knowing same.

i have seen many approaches, using 'translation' table. you'd news_translation, products_translation , agenda_translation.

is there solution this, without need of adding translation table every component?

thanks in advance.


Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -