I'm building a website where I plan to support multiple languages. Not only via UI, but via the content too.
I have several tables where I have text columns such as "title", "name", "description", "body" and so on. What's the best way to do so? Will I have to create an additional table for each one where I have text data I want to translate? For instance:
articles(id) articles_content(article_id, title, description, body, language_id) comments(id) comments_content(comment_id, body, language_id)
And thus for each table I want to translate.
Any downsides of this solution?
Is there a better and yet simpler way?