Wrong month shows for July when culture is set to ar-AE in asp.net webform

Question

Website show wrong month for julyin arabic, this is Arabic website developed in asp.net webform and culture is set properly to 'ar-AE' and event date shows correct month on local machine but on productions it show month which belongs to Egyptian culture

Date in database is stored as smalldatetime in this format 2017-07-25 00:00:00

Wrong month for July

Correct month on local-host :25 يوليو 2017

Wrong month on production : 25 يوليه 2017

<asp:Label  ID="lblDate"  runat="server"  Text='<%# FormatDate(Eval("PublishDate")) %>'>
</asp:Label>

protected string FormatDate(object dt) {
  string date = String.Format("{0:MMMM dd, yyyy}", dt);
  date = String.Format("{0:dd MMMM yyyy}", dt);
  // Response.Write(date + "<br/>");
  return date;
}

Culture is set to UAE correctly

protected override void InitializeCulture() {
  String lang = "ar-AE";
  CultureInfo ci = System.Threading.Thread.CurrentThread.CurrentUICulture;
  // Call function to detect Language and assign  to session variable
  Thread.CurrentThread.CurrentCulture = new CultureInfo(lang);
  Thread.CurrentThread.CurrentUICulture = new CultureInfo(lang);

  base.InitializeCulture();
}

What could be the reason, could it be production server itself?

We check almost all possibilities and tried everything, it just gets wrong month for July rest all is ok.

I also cross check production server Language setting, IIS settings, it all seems to be okay, only thing i can point is that server has all latest updates, may be we are missing something. we tested same on different windows 7 machine it just works fine.

Update: I have tried solution suggest also but it keeps showing wrong month for JULY يوليه. This is wrong. We tested it also it show the correct culture on the server.

Fiddle example also show wrong month https://dotnetfiddle.net/ZAOJ7H

Answer 1

I tried to find localized DateTime month name by using these lines of code:

DateTime dt = DateTime.Parse("2017-07-25 00:00:00");

string arabicMonth = new CultureInfo("ar-AE").DateTimeFormat.GetMonthName(dt.Month);

The resulted code gives يوليه instead of يوليو, indicating something went wrong in Windows localization of Gregorian month names in Arabic language.

By finding out a little bit, it caused by locale.nls file located in %WINDIR%\System32\locale.nls containing incorrect data where the month of July is displayed in other Arabic version than current system culture using.

Since NLS file is formatted in binary, it's hard to read and edit stored locale information even viewing it in hex editor. AFAIK, this problem already fixed by Microsoft in KB981981 update for Windows 7 & Server 2008 R2 systems, you can perform update depending on platform used (requires restart afterwards):

Update for Windows 7 32-bit (KB981981) - 5/24/2010

Update for Windows 7 64-bit (KB981981) - 5/24/2010

NB: Ensure that all affected machines installed with this update for best result. If you can't install the update due to certain restrictions, I suggest to try using jQuery plugin for datepicker which shows يوليو for month of July as workaround.

PS: I also tried zahed's solution in the OP's fiddle -

DateTime.Parse("2017-07-25 00:00:00").ToString("dd dddd , MMMM, yyyy", new CultureInfo("ar-AE"))

But it shows 25 الثلاثاء , يوليه, 2017 (i.e. يوليه) too, hence it's not the string formatting problem, instead the Windows localization problem as explained above.

References:

Description of Software Update Services and Windows Server Update Services changes in content for 2010

How to convert the month name in english text in datetime to arabic text using C#?

Related:

Michael S. Kaplan - Arabic locales for month names

Answer 2

Design code:

<div>
    <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
    <asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click">LinkButton</asp:LinkButton>
</div>

Code behind C#:

protected void LinkButton1_Click(object sender, EventArgs e)
{
    Label1.Text = DateTime.Parse("2017-07-25 00:00:00").ToString("dd dddd , MMMM, yyyy", new CultureInfo("ar-AE"));
}

Updated answer:

I would imagine all languages that the OS supports (considering that is where the information comes from).

Here is a list: default supported languages by OS.