Bug #37957 wrong name in LC_TIME_NAMES
Submitted: 8 Jul 2008 8:04 Modified: 18 Aug 2009 15:37
Reporter: Emad Falsafi Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Charsets Severity:S1 (Critical)
Version: OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[8 Jul 2008 8:04] Emad Falsafi

Kann Jemand mir erklären, was bedeutet "ar_IN: Arabic - Iran", es gibt KEIN arabic im Iran Wir sprechen Farsi (Persisch).
can everyone say me, wat is ("ar_IN: Arabic - Iran")?
we speak in Iran Farsi(Persian) NOT Arabic.

How to repeat:

im Iran sprechen Wir Farsi(Persisch).

we speak in Iran Farsi(Persian) NOT Arabic.

Suggested fix:
[8 Jul 2008 11:08] Susanne Ebrecht
Many thanks for writing a bug report.

I made some more researches here and it should be fa_IN.

But this names are not from us. They are from the operating System. 
They are given by ISO 639. That's a standard.

You can get a little bit more informations about that here:

After I researched a little bit longer I also found this:

Main language of Iran is Persian.
Also there is a fa_IN.

The minimum we can do is to change this.

But I figured out some more issues with this page that I have to discuss with my documentation colleagues.

I will change topic here and we will look that we can change documentation.
[8 Jul 2008 11:58] Susanne Ebrecht
After some more researches this is a MySQL bug.

The names are made by MySQL itself and don't came from the OS.

There was/is a bug in some Linux distributions about that. According to FreeBSD, Ubuntu and Debian and according to wikipedia the right name should be fa_IN and not ar_IN.
[18 Aug 2009 15:37] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

ar_IN is Arabic - India. I've corrected this and several other locale names in the manual per IANA values.