Localization.Brain Storming.

Hello,

I am working on a Blog and a Documents systems.
What I need is:
1. Each blog can have various language versions.
2. Each document can have various language versions.

I have been thinking about this and I end up with two approaches:
1. Use a structure where all tables depend on a localized table:
BLOGS
|-- BlogsLocalized
|-- BlogsPosts
|-- BlogsRatings
|-- BlogsComments

2. Use a structure where each table has a localized version
BLOGS
|-- BlogsLocalized
|-- BlogsPosts
|-- BlogsPostsLocalized
|-- BlogsComments
|-- BlogsCommentsLocalized

3. Create a simpler, without localization, in SQL and in my web sites have different versions for each language.

The same approach is under thinking for DocumentsTables.

Could someone give me some advice?

I have been looking in internet but until no I couldn't find anything really useful.

Thanks,
Miguel

Hi Miguel,

I would suggest the 3rd way.

In the database, you only store a simple version of the blog contents. But in your website, you can have serveral resource files that contains all the languages for the web site.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!