Torsten Zühlsdorff <foo@meisterderspiele.de> writes:
> Now for the Problem: There is a problem with the translation of the
> english word "March" to the german "M�rz". Instead of "M�rz" i get
> "M�Rz" (with uppercase "r").
> You can reproduce it as follow:
> # SET lc_time = "de_DE.UTF-8";
> # SELECT to_char('2011-03-04 00:00:01'::date, 'TMMonth YYYY');
> to_char
> -----------
> M�Rz 2011
I can reproduce the above when the database encoding is not UTF8 or
lc_ctype isn't a UTF8 locale. The reason is that TMMonth implies
applying an initcap transformation to the month name retrieved from
the locale library. The only way initcap will make the right choice
of what to do with the "r" is if it thinks that � is a letter.
Which it won't if the encoding is wrong or lc_ctype isn't set to
classify � as a letter. This does not seem like a bug to me
though, just misconfiguration.
regards, tom lane