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