Re: BUG #4451: initcap() function capitalizes incorrectly

Note sure what the correct settings should be, but output from SHOW
ALL in psql says:

lc_collate C
lc_ctype C

On Mon, Oct 6, 2008 at 5:37 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
>> Scott V wrote:
>>> PostgreSQL version: 8.3.1
>>> Operating system: Mac OS X 10.5.4
>
>>> initcap() capitalizes incorrectly when passing strings containing certain
>>> two-byte UTF-8 characters. E.g., when argument = 'mātūrāte', initcap
>>> returns 'MāTūRāTe'. Correct result should be 'Mātūrāte'.
>
>> What's your setting for lc_collate?
>
> I think actually it's lc_ctype that determines case-folding. But the
> current theory is that Apple's locale support is simply broken for
> UTF-8:
> http://archives.postgresql.org/pgsql-general/2008-02/msg01072.php
> which means that even if Scott had all his settings right, it wouldn't
> work :-( A quick test on OS X here seems to confirm this.
>
> regards, tom lane
>