Topic: Design for blog in two languages
Hi what is peoples thoughts on building a simple blog to have posts in more than one language.
I have started buy having a content tables for the lanugages and then in the actual post table i hold id's to the actual content.
So example would be
id = 1
title = 99
body = 100
99 Hello world
100 This is the first post.
99 Hola mundo
100 esta es la premero post.
Then depending on what language the user is on i switch the content tables.
Has anyone else implemented a multi lingual app and have they used a different approach to this.