Solved

Multilanguage Content

Posted on 2008-10-19
2
1,279 Views
Last Modified: 2012-05-05
Hello. I'm working on a website with Asp.Net/C#. I read data from my sql 2005 server tables and with this data I fill text fields and Drop Down List components. I would like to fill those dropdownlists and textfields with content varying with selected browser languages. I would begin with two languages.. english and italian for example.

the question is: Should I build a multilanguage database somehow, or should I keep db in one language and translate everithing elsewhere before filling dropdownlist for ex. ?

what do you think about it? and.. how do I do? :)

thank you
0
Comment
Question by:ziggie301
2 Comments
 
LVL 16

Accepted Solution

by:
Gyanendra Singh earned 500 total points
ID: 22751944
0
 
LVL 13

Expert Comment

by:iHadi
ID: 22754029
That depends on your website nature

If the words in the database are known in advance, then preparing a translation list and loading it into memory to used to perform translation would be a good thought.

But if the words come from systems or users and you cannot predict them all, or you are dealing with text and phrases, then I think it would be better to save the data to a database for each language.

I've been designing and working on a multilingual CMS for 4 months and it's comming out great, so if you need nay help on how to design your multilingual app, I'll be happy to help
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question