MySQL Bugs: #37957: wrong name in LC_TIME

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:	None
Category:	MySQL Server: Charsets	Severity:	S1 (Critical)
Version:		OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
http://dev.mysql.com/doc/refman/5.1/en/locale-support.html

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:
http://dev.mysql.com/doc/refman/5.1/en/locale-support.html

im Iran sprechen Wir Farsi(Persisch).

we speak in Iran Farsi(Persian) NOT Arabic.

Suggested fix:
http://dev.mysql.com/doc/refman/5.1/en/locale-support.html

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:
http://msdn.microsoft.com/en-us/library/ms776389(VS.85).aspx

After I researched a little bit longer I also found this:
http://en.wikipedia.org/wiki/Persian_language

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.

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.

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.