I have read some articles written about how some products like Office 2010 by default support not only Hijri Date but also support UmAlQura Date and this good news. This article show you some points related to Arabic language (which is my mother tongue) with Sql Server. In general Sql server deals with any language in the same way except some issues become different from language to other language. So let's begin by Collation and see how Sql Server stored data and retrieve data in Arabic language. What is a Collation? A collation determines the rules SQL Server uses to compare and sort character data and determines which characters can be stored in non-Unicode character data types. Collation can be specified at the instance level, database, column level or clause level. So let's begin by this example to make the points clear: 01.CREATE TABLE [dbo].[Test]( 02.--here stored data as ASCII char 03.[Name_Char_Latain] [char](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,...