I have an Asp.Net 4.0 CMS application developed in in english language, as per client requirement he wants the application should allow the user to manage the data in Arabic and English, Could anybody let me know is there any way where i can use both languages
based on the option selected. And one more question how the data will be stored in SQL Database in English or have to store into 2 different database depend on the languages.
In some cases when user enter info into arabic language and it store in SQL Database as English language, My Query is when we retrieve the info using Arabic language is it properly translated as we have entered ?, because sometime its not properly translated
what we have entered.
the best practice for multiple language is to create different fields to store their content in the database. Whenever the user changes the languages, you need to fetch the related contents from the db according to the language.
hope this helps, thanks.
Please mark the replies as answers if they help or unmark if not.
Feedback to us
shabbir_215
Member
427 Points
419 Posts
Multi Language in ASP.NET 4.0
Jun 06, 2011 12:56 PM|LINK
Hi All,
I have an Asp.Net 4.0 CMS application developed in in english language, as per client requirement he wants the application should allow the user to manage the data in Arabic and English, Could anybody let me know is there any way where i can use both languages based on the option selected. And one more question how the data will be stored in SQL Database in English or have to store into 2 different database depend on the languages.
Thanks in Advance
Shabbir
anujtripathi
Contributor
3759 Points
595 Posts
Re: Multi Language in ASP.NET 4.0
Jun 06, 2011 01:21 PM|LINK
If you google it you will get tons of tutorial guiding the same . To store it in the database use data type NVARCHAR.
Hope this will help
Please remember to click “Mark as Answer” on the post that helps you, it will help other(s) to get there answer.
shabbir_215
Member
427 Points
419 Posts
Re: Multi Language in ASP.NET 4.0
Jun 06, 2011 04:25 PM|LINK
In some cases when user enter info into arabic language and it store in SQL Database as English language, My Query is when we retrieve the info using Arabic language is it properly translated as we have entered ?, because sometime its not properly translated what we have entered.
Thanks
Shabbir
Yanping Wang...
Star
14919 Points
1537 Posts
Microsoft
Re: Multi Language in ASP.NET 4.0
Jun 10, 2011 08:43 AM|LINK
Hi Shabbir,
thanks for you post.
how to store arabic in SQL database please refer: http://stackoverflow.com/questions/3560173/store-arabic-in-sql-database
the best practice for multiple language is to create different fields to store their content in the database. Whenever the user changes the languages, you need to fetch the related contents from the db according to the language.
hope this helps, thanks.
Feedback to us
Develop and promote your apps in Windows Store
shabbir_215
Member
427 Points
419 Posts
Re: Multi Language in ASP.NET 4.0
Jun 10, 2011 09:08 AM|LINK
Hi Yanping
Thanks for your reply, Your comment was really helpful.
Thanks
Shabbir