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: | |
| 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 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.
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)