Solved

Multilanguage Content

Posted on 2008-10-19
2
1,303 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
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.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

626 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