WL#5303: Romansh locale for DAYNAME, MONTHNAME, DATE_FORMAT
Affects: Server-5.6
—
Status: Complete
If @@lc_time_names='rm_CH', DAYNAME() and MONTHNAME() and
DATE_FORMAT() functions should produce appropriate Romansh
results for day abbreviation, day, hours am/pm,
month abbreviations, and months.
Apply the contributed patches as explained in
BUG#50915 "Romansh language patch for MySQL server".
Functions DAYNAME, MONTHNAME, DATE_FORMAT currently do not support
Romansh locale.
This task will add rm_CH locale with appropriate month/day names.
Days
----
day abbreviation: (abday):
Sunday = "du"
Monday = "gli"
Tuesday = "ma"
Wednesday = "me"
Thursday = "gie"
Friday = "ve"
Saturday = "so"
day:
Sunday = "dumengia"
Monday = "glindesdi"
Tuesday = "mardi"
Wednesday = "mesemna"
Thursday = "gievgia"
Friday = "venderdi"
Saturday = "sonda"
Hours
-----
am= "AM"
pm= "PM"
Months
------
month abbreviation: (abmon):
Jan = "schan"
Feb = "favr"
Mar = "mars"
Apr = "avr"
May = "matg"
Jun = "zercl"
Jul = "fan"
Aug = "avust"
Sep = "sett"
Oct = "oct"
Nov = "nov"
Dec = "dec"
month: (mon):
January = "schaner"
February = "favrer"
March = "mars"
April = "avrigl"
May = "matg"
June = "zercladur"
July = "fanadur"
August = "avust"
September = "settember"
October = "october"
November = "november"
December = "december"
Unaffected locale uses
----------------------
For "FORMAT(X,D[,locale])", which is not a linguistic issue,
'rm_CH' should produce the same format as 'de_CH'.
For lc_messages='rm_CH', use the English messages.
Authority
---------
The month and day names are what one would expect for Romansh (Grischun).
From a comment on BUG#50915 by Beat Vontobel, who supplied a patch:
"
Peter, the short answer is: Yes, the abbreviations used in this patch are
those suggested by the "Pledari Grond" for "Rumantsch Grischun", as
maintained by the "Lia Rumantscha" (http://www.liarumantscha.ch/).
"Rumantsch Grischun" is what's now officially used on the
national and state (Canton of Graubuenden) level in writing.
The vocabulary can be accessed online at http://www.pledarigrond.ch/ - enter
the full German or Romansh words for month/weekday names and you'll also
get the Romansh abbreviations for your own verification.
"
This has been confirmed.
References
----------
BUG#50915 Romansh language patch for MySQL server (feature request)
Copyright (c) 2000, 2025, Oracle Corporation and/or its affiliates. All rights reserved.