?
Solved

Set language Arabic in sql server 2008

Posted on 2009-12-26
10
Medium Priority
?
3,318 Views
Last Modified: 2012-05-08
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
0
Comment
Question by:ali_alannah
  • 4
  • 4
  • 2
10 Comments
 
LVL 43

Expert Comment

by:pcelba
ID: 26127748
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.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26130787
>> 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..
0
 
LVL 43

Expert Comment

by:pcelba
ID: 26132176
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?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26135294
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.
0
 
LVL 43

Expert Comment

by:pcelba
ID: 26137626
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
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26151351
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..
0
 

Author Comment

by:ali_alannah
ID: 26338800
Hi rrjegan17:
How can i report microosft for this issue is there any email for reporting bugs to Microsoft ?
0
 
LVL 43

Accepted Solution

by:
pcelba earned 1500 total points
ID: 26340912
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26341265
pcelba got the links correctly..
0
 

Author Closing Comment

by:ali_alannah
ID: 31670097
Good
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question