How to convert english to arabic in Sql Server 2012?

  • Hi Folks,

    I have a data like "Associate Prof,Assistant Prof,Female,Male,Unknown,Single,Married,Chinese,Indian,,Malay,Others".
    (Table:- TEMP_LIV, Column:- Lookup_Value, Lang_Name)

    I want to change the above seeded data into arabic. with out using google translation, how to change it in arabic...

    Is there any simple solution, Please help....

    Thanks in advance..
    Venal.

  • Database's don't recognise languages; to them a "female" and "femelle" are just two strings (one 6 characters, one 7). If you need to change the language of your data or objects, you, or someone, will need to translate each one by updating the record/object. If you don't want to use Google Translate, that means employing someone to do it for you who can speak both Arabic and English (as I assume the reason you don't want to use Google is because you don't speak one of the languages).

    Yes, there are some items that SQL Server does recognise languages for, for example dates. It knows that April is English and Avril is French for the 4th month of the year. This is more of a display thing to make it easier for users. It doesn't have a comprehensive dictionary for every language. It just knows a few simple words. Even then, if you were logged in as a French user and entered the date '11-April-2017', SQL Server would not be "clever" enough to notice your date is in English and realise you meant Avril, it would simply state the date value is invalid.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Venal - Wednesday, June 28, 2017 12:55 AM

    I want to change the above seeded data into arabic. with out using google translation, how to change it in arabic...

    Is there any simple solution, Please help....

    Get someone who speaks both languages to translate it for you, or use one of the AI translators.

    You'll need nvarchar columns to store the Arabic characters once they've finished.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply