Hi,
I’m currently working on an app for a video sharing website. I have at this stage manticore working with english language, however the app will support several languages. Each video has a title (original language) and a translated title for each language (example zh, ro, ru…probably all supported languages by google translate). What is the best approach to make this work? I have the following ideas:
- One table for each language (video_id, title)
- One table for all languages (different columns title_zh, title_ro, title_ru)
- One table for all languages (one mixed column)
Are there any articles where i could read about this?
Thank you!