asked on

Set language Arabic in sql server 2008

Hello
when i write the following statement
set language ITALIAN
select datename(weekday,getdate())
it comes with italian name of datename , that's good
But when i tried the following
set language ARABIC
select datename(weekday,getdate())

it comes in English not in arabic
i tried many language Korean , russian and it comes good , but in Arabic it comes with english

Pavel Celba

The regional format of date parts is given by sys.syslanguages view contents. You may try:

SELECT * FROM sys.syslanguages

and it seems the SQL Server installation does not have Arabic date parts defined properly.

But the following conversion works:
SELECT CONVERT(nchar, GETDATE(), 130)

It seems you will need to convince Microsoft for a change or use some work around like described e.g. here:
http://forums.asp.net/p/1422004/3160700.aspx

To create a function as Arabic replacement of Datepart should be very easy.

Raja Jegan R

>> it comes in English not in arabic

Do you have Arabic language installed in that server..
Hope you have Italian language installed in your OS where SQL Server resides.
Kindly confirm..

Pavel Celba

rrjegan17, I don't have Corean and Japanese languages installed on my copmputer but SQL Server is able to return date names in these languages. The Arabic language is a MSFT mistake.

Unfortunately, there is no possibility to update the syslanguages table on SQL 2008 even not in admin mode... Or do you know how to update this table?

Raja Jegan R

pcelba,

>> The Arabic language is a MSFT mistake.

Kindly try setting the default Language to Arabic for that database and give it a try..
(currently I dont have access to a server and will test it out shortly)

>> Unfortunately, there is no possibility to update the syslanguages table on SQL 2008 even not in admin mode... Or do you know how to update this table?

No, Starting from 2005 you can't update a system table.

Pavel Celba

When I set the language to japanese all messages are in Japanese, Russian switches it also etc. Arabic uses English even when the Database collation is Arabic and language is Arabic.

Attached is the sys.syslanguages table printscreen.

But I did not try to install SQL Server on Arabic Windows.

Untitled.jpg

Raja Jegan R

pcelba,
Yes, Just tried to check as you mentioned and you are correct..
Entries for Arabic Language contains English values instead of the Arabic ones and hence the issue..

ali_alannah,
Just report this bug / issue to Microsoft so that it can be handled in further releases..

Ali Saad

ASKER

Hi rrjegan17:
How can i report microosft for this issue is there any email for reporting bugs to Microsoft ?

ASKER CERTIFIED SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Raja Jegan R

pcelba got the links correctly..

Ali Saad

ASKER

Good