ziggie301
asked on
Multilanguage Content
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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