June 28, 2017 at 12:55 am
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.
June 28, 2017 at 1:51 am
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
June 28, 2017 at 3:51 am
Venal - Wednesday, June 28, 2017 12:55 AMI 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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply