Bug #22644 LC_TIME_NAMES: Some names are doubtful

Submitted: 24 Sep 2006 19:41 Modified: 11 Oct 2006 17:54
Reporter: Peter Gulutzan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:5.1.12-beta-debug OS:Linux (SUSE 10.0 / 64-bit)
Assigned to: Assigned Account CPU Architecture:Any

[24 Sep 2006 19:41] Peter Gulutzan
Description:
I can say SET LC_NAMES = 'x', where x indicates a language,
such as 'en_US', 'de_DE', and many others.

But the names of months and days sometimes look doubtful to me.
I am looking at the source file, /mysql-5.1/sql/sql_locale.cc.

Arabic: The names are all spaces; obviously wrong
Czech: The names are right, but why are they capitalized?
Korean: Month names are full, but I've read they should be digit+day
        as in Chinese/Japanese:
        http://sourceware.org/ml/bug-glibc/2003-09/msg00198.html
Portuguese: The names are right, but why are they capitalized?
            And why Segunda instead of segunda-feira etc.?
            [ Minor note: the .cc file comment should say "Portuguese" never "Portugese" ]
Romanian: Romanian 'ro_RO' has SîmbĂtĂ for Saturday; obviously wrong
Russian: The month names are genitive, why not nominative?
         [ Oddly, for 'ru_UA' they're nominative, for 'ru_RU' they're genitive ]
         ... All other Slavic languages should be checked for the same possible error
Serbian: The names are in Latin script, why not Cyrillic?
         [ Minor note: the .cc file comment should say "Serbian" never "Servian" ]

Since finding doubtful names isn't hard for the few languages that I
know well enough to look up, I conclude that all must be re-checked.
(I have checked the essential languages and they look okay except as noted above.)
For any language that can't be proven right quickly, I suggest that
MySQL should remove the option. "Something is better than nothing"
is a bad motto.

How to repeat:
mysql> SELECT DAYNAME('2001-01-01');
+-----------------------+
| DAYNAME('2001-01-01') |
+-----------------------+
| Segunda               |
+-----------------------+
1 row in set (0.00 sec)
[24 Sep 2006 23:38] MySQL Verification Team
Thank you for the bug report.

mysql> SELECT DAYNAME('2001-01-01');
+-----------------------+
| DAYNAME('2001-01-01') |
+-----------------------+
| segunda               | 
+-----------------------+
1 row in set (0.00 sec)
[26 Feb 2009 7:03] Sveta Smirnova
Bug #43207 was marked as duplicate of this one.

Bug #43207 contains patch for ro_RO and information about additional defect:

DuminicĂ for Sunday is wrong.
[18 Nov 15:03] Øystein Grøvlen
Posted by developer:
 
Checked MySQL Community Server 26.10.0 with both optimizers, plus 8.0.46, 5.1.31, 5.1.40 and 5.1.41.

According to Codex, the report is only partly resolved:

- Romanian Saturday/Sunday: 5.1.40 returns SîmbĂtĂ and DuminicĂ, with abbreviation Sî. Version 5.1.41 returns Sâmbătă and Duminică, with abbreviation Sâ. The corrected spellings remain in 8.0.46 and 26.10.0. This matches the fix for Bug #11752109 / public #43207, WRONG LC_TIME NAMES FOR ROMANIAN LOCALE.
- Arabic: all 18 tested ar_* locales return nonblank month and weekday names, including on 5.1.31. No fixing release was established for the original blank-name observation.
- Czech: month names are lowercase, but weekdays remain capitalized, for example Pondělí.
- Portuguese: pt_BR returns janeiro and segunda; pt_PT returns Janeiro and Segunda. The full weekday form segunda-feira is still not returned.
- Korean: MONTHNAME returns written-out names, for example 일월; DATE_FORMAT with %b returns a numeric form, for example a leading space followed by 1월.
- Russian: ru_RU returns Января, while ru_UA returns Январь. The different grammatical forms remain. Genitive is valid in a full date; standalone month names can require nominative. Replacing genitive universally would therefore not address all formatting contexts.
- Serbian: sr_YU and sr_RS return Latin-script names on the current release. Latin script is valid Serbian; this observation alone does not prove an incorrect translation.

DAYNAME/MONTHNAME and the corresponding DATE_FORMAT fields were checked for all seven weekdays and twelve months. Output was identical between the two optimizers on 26.10.0.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.056 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.