CODEWITHSUNDEEP
c#sqlasp.net-mvc
Orion Rigel
Orion Rigel

Reputation: 95

database for arabic and english language MVC SQL

I am developing one application where the client wants to see contents in both arabic and english. The displayed data is retrieving from database SQL.

The question here is If the user saves his details in database in english language, how can i show that data in arabic from database?

How can i achieve this part?

Upvotes: 0

Views: 923

Answers (3)

Midhun Mundayadan
Midhun Mundayadan

Reputation: 3182

i think An effective way to create localized Web pages is to use resource objects for your page's text and controls. By using properties placed in resource objects, ASP.NET can select the correct property at run time according to the user's language and culture. The process is straightforward:

Resource Files and ASP.NET MVC Projects

fore more info

Upvotes: -1

CodingGorilla
CodingGorilla

Reputation: 19842

I don't know how you can do that without using some sort of translation service, there is nothing in .NET or SQL server (or any other RDBMS that I know of) that will do that for you.

Here's one (API) that is from Microsoft if you need a place to start: https://www.microsoft.com/en-us/translator/translatorapi.aspx

Depending on your requirements, you may want to translate data immediately and store it into the opposite database; however it may end up being expensive, so if you're able you might choose to translate things on demand to save some costs.

Upvotes: 1

It's a trap
It's a trap

Reputation: 1353

You have to use a translator API and save both the languages to database.

Upvotes: 1

Related Questions