WL#4642: Greek locale for DAYNAME, MONTHNAME, DATE_FORMAT

Affects: Server-5.5 — Status: Complete — Priority: Medium

If @@lc_time_names='el_GR', DAYNAME() and MONTHNAME() and
DATE_FORMAT() functions should produce appropriate Greek
results for day abbreviation, day, hours am/pm,
month abbreviations, and months.
This task is a part of Sun Globalization Requirements.

Functions DAYNAME, MONTHNAME, DATE_FORMAT currently do not support
Greek locale (Tier 2).

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

This task will add el_GR locale with appropriate month/day names.

Days
----

day abbreviation: (abday):

Sunday = Κυρ "<U039A><U03C5><U03C1>";
Monday = Δευ "<U0394><U03B5><U03C5>";
Tuesday = Τρί "<U03A4><U03C1><U03AF>";
Wednesday = Τετ "<U03A4><U03B5><U03C4>";
Thursday = Πέμ "<U03A0><U03AD><U03BC>"
Friday = Παρ "<U03A0><U03B1><U03C1>";
Saturday = Σάβ "<U03A3><U03AC><U03B2>";

day:

Sunday = "Κυριακή" = "<U039A><U03C5><U03C1><U03B9><U03B1><U03BA><U03AE>"
Monday = "Δευτέρα" = "<U0394><U03B5><U03C5><U03C4><U03AD><U03C1><U03B1>"
Tuesday = "Τρίτη" = "<U03A4><U03C1><U03AF><U03C4><U03B7>"
Wednesday = "Τετάρτη" = "<U03A4><U03B5><U03C4><U03AC><U03C1><U03C4><U03B7>"
Thursday = "Πέμπτη" = "<U03A0><U03AD><U03BC><U03C0><U03C4><U03B7>"
Friday = "Παρασκευή" =
"<U03A0><U03B1><U03C1><U03B1><U03C3><U03BA><U03B5><U03C5><U03AE>"
Saturday = "Σάββατο" = "<U03A3><U03AC><U03B2><U03B2><U03B1><U03C4><U03BF>"

Hours
-----

am= "πμ" = "<U03c0><U03bc>"
pm= "μμ" = "<U03bc><U03bc>"

Months
------

month abbreviation: (abmon):

Jan = <U0399><U03B1><U03BD>
Feb = <U03A6><U03B5><U03B2>
Mar = <U039C><U03AC><U03C1>
Apr = <U0391><U03C0><U03C1>
May = <U039C><U03AC><U03B9>
Jun = <U0399><U03BF><U03CD><U03BD>
Jul = <U0399><U03BF><U03CD><U03BB>
Aug = <U0391><U03CD><U03B3>
Sep = <U03A3><U03B5><U03C0>
Oct = <U039F><U03BA><U03C4>
Nov = <U039D><U03BF><U03AD>
Dec = <U0394><U03B5><U03BA>

month: (mon):

<U0399><U03B1><U03BD><U03BF><U03C5><U03AC><U03C1><U03B9><U03BF><U03C2>
<U03A6><U03B5><U03B2><U03C1><U03BF><U03C5><U03AC><U03C1><U03B9><U03BF><U03C2>
<U039C><U03AC><U03C1><U03C4><U03B9><U03BF><U03C2>
<U0391><U03C0><U03C1><U03AF><U03BB><U03B9><U03BF><U03C2>
<U039C><U03AC><U03B9><U03BF><U03C2>
<U0399><U03BF><U03CD><U03BD><U03B9><U03BF><U03C2>
<U0399><U03BF><U03CD><U03BB><U03B9><U03BF><U03C2>
<U0391><U03CD><U03B3><U03BF><U03C5><U03C3><U03C4><U03BF><U03C2>
<U03A3><U03B5><U03C0><U03C4><U03AD><U03BC><U03B2><U03C1><U03B9><U03BF><U03C2>
<U039F><U03BA><U03C4><U03CE><U03B2><U03C1><U03B9><U03BF><U03C2>
<U039D><U03BF><U03AD><U03BC><U03B2><U03C1><U03B9><U03BF><U03C2>
<U0394><U03B5><U03BA><U03AD><U03BC><U03B2><U03C1><U03B9><U03BF><U03C2>

month (using text notation):
January = "Ιανουάριος"
February = "Φεβρουάριος"
March = "Μάρτιος"
April = "Απρίλιος"
May = "Μάιος"
June = "Ιούνιος"
July = "Ιούλιος"
August = "Αύγουστος"
September = "Σεπτέμβριος"
October = "Οκτώβριος"
November = "Νοέμβριος"
December = "Δεκέμβριος"

Nynorsk
-------

During discussion about this WL and WL#751 it appeared
that we're missing the Norwegian Nynorsk locale.
It was decided that Nynorsk will be a separate worklog task,
WL#4814 Norwegian Nynorsk locale for DAYNAME, MONTHNAME, DATE_FORMAT

Authority
---------

None. See comment on BUG#39092 regarding ΕΛΟΤ.

On Linux distributions one can find a file named /usr/share/i18n/locales/el_GR
but we do not follow it. For example our day abbreviations are as in Vista.

References
----------

BUG#39092 Greek LOCALE support (feature request)

dev-private email thread "WL#4642 Greek locale for DAYNAME, MONTHNAME,
DATE_FORMAT, some questions" starting at
[mysql intranet]/secure/mailarchive/mail.php?folder=4&mail=26821

You must be logged in to tag this worklog

No Comments yet

Votes

Not yet rated.
You must be logged in to vote.

Watches

0 members are watching this worklog
You must be logged in to track this worklog.

Provide Feedback

Please note:
HTML will be purified, but we allow for a number of HTML tags so that you have the flexibility to decorate your comment text to some extent. The comments allow the following HTML tags:

strong, b, em, blockquote, a, code, pre

To put code into your comment, simply encapsulate your code with
[code language="XXX"][/code], where XXX is any common language, for instance "PHP", "SQL", "C", etc.



You must be logged in to comment