Last post Oct 26, 2010 04:29 PM by haitham khedre
Oct 25, 2010 01:28 PM|dikran|LINK
I am developing a multi language site that has 40 languages. The database is relatively small both data and table Count.
I need to display the contents in 40 different languages.
Whats the best way to go about this?
should I translate the content and store the translated data in the database (40 different times)?
should I translate the content at runtime using a translation service like google translate?
its the large number of languages thats scary.
Oct 25, 2010 02:31 PM|Haitham Khedre|LINK
just create the 40 language pack and make other resource or Technical writer fill them for you , so you keep working
while site is translated.
Oct 25, 2010 05:15 PM|dikran|LINK
thnks 4 the quick reply, but my question was abt the contents which is inputed by users and stored in a database.
whats the best practice here? store the same content 40 times in the database in different languages(any guidelines)? create seperate db for each language? create 40 versions of each table? store everything in english and have a web service translate it
at runtime(know any service)?
I didnt mean the resources.
Oct 26, 2010 08:40 AM|Huske|LINK
You could create one lookup table with languages and ID of each language, then create another table where you have Translation, like:
This is just something from top of my mind. You might not agree with the design, but the design is your decision and totally up to you.
As for the translation, it is always better to have a human being translating it. I had a translation done by Google Translation a few months ago and it made no sense whatsoever.
In a case like yours, you should keep it in a database for the sake of maintenance and administration. If you have a simple requirement then keep everything in one table, but if you have any special requirements then plan your architecture in as much details
Oct 26, 2010 04:29 PM|Haitham Khedre|LINK
there is no online translator service that will give you 40 accurate translation , if this feature is very important you will need to do it your self
if not try to use google translate and that is it.